Sunday, 4 September 2011

Replace Command in SQl


REPLACE FUNCTION TAKES THREE ARGUMENT


 REPLACE('STRING',REPLACE FROM,REPLACE WITH)

select Replace('123000/250000/14/10/23568','/,'-') as t

output:- 123000-250000-14-10-23568

HAVE A GOOD DAY...