thanks raj

i found out myself. thanks:) the answer is below: SELECT datename(dw,getdate()) raj

You could soemthing like this, not very clever but it works and you could alway put it in an UDF. declare @Mob varchar(50) set @Mob = '0122-1230-123' set @Mob = REPLACE( @Mob , '-', '') set @Mob = REPLACE( @Mob , ' ', '') set @Mob = REPLACE( @Mob , '/', '') set @Mob = REPLACE( @Mob , 'T', '') set @Mob = REPLACE( @Mob , '\', '') SELECT @Mob Results -------- 01221230123 Look where you want to go not where you don't want to crash. Bikers Bible

I found the bug, now working fine… Thanks raj

Thank you so much Steve for your kind advise. i will try this method...