Database

jrahma wrote:

something like this (but throwing error!)

Bastard Programmer from Hell

select ('973' + contact_moblle) AS mobile_number from persons where contact_moblle is not null and contact_moblle != '' and len(contact_moblle) = 8 and left(contact_moblle, 1) = '3' GROUP BY contact_moblle order by file_no

;With CTE AS
(
	Select 
	     Rn = Row_Number() Over(Partition By ('973' + contact_moblle) Order By file_no)
	     ,('973' + contact_moblle) AS mobile_number 
	from persons 
	where contact_moblle is not null 
	and contact_moblle != '' 
	and len(contact_moblle) = 8 
	and left(contact_moblle, 1) = '3' 
)

Select mobile_number
From CTE
Where Rn = 1

select regexp_replace(d_name,'Mc[a-z]', 'Mc' || upper(substr(d_name, 3, 1))) n from
(
select 'Mcfix' d_name from dual
);

Stan Moong wrote:

reporting application

Stan Moong wrote:

3) Using C# for front-end and MS SQL Server Express as back-end.