Neeraj
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...
No comments:
Post a Comment
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment