Insert Dashes In Between Numbers Using SQL
Can anyone help with this???????. IF i have a ssn like 123459636 and i want to insert dashes into it how would i do that in SQL; i have tried but dint get Result like "123-45-9636". i got "-9636"
Replies
-
Anoop Kumarcheck this out..
#-Link-Snipped-#
like:
SELECTSUBSTRING(ACCOUNTNUMBER,1,3)+'-'+SUBSTRING(ACCOUNTNUMBER,4,5)+'-'+SUBSTRING(ACCOUNTNUMBER,9,2)FROM BILLING.ACCOUNT
and
SELECTLEFT(ACCOUNTNUMBER,3)+'-'+SUBSTRING(ACCOUNTNUMBER,4,5)+'-'+RIGHT(ACCOUNTNUMBER,2)FROM BILLING.ACCOUNT -
Tehreemqok thank u...
You are reading an archived discussion.
Related Posts
Hi all,
I want to write a script in perl which will execute under gdb (is it possible in perl? or i will have to use python) to automate the...
how should we find projects at the end of first year and also on which topic we should start learning to get a good project(computer science based)??
The next generation XBOX might get a new official name - XBOX Infinity with a tag-line 'Infinite Entertainment. Infinite Possibilities.'. A leaked image on Reddit shows a new logo &...
The unmanned X-51A WaveRider experimental aircraft was test-flown off the Southern California coast and it did an impressive Mach 5.1 - about 5 times the speed of sound. The aircraft...
hello dear,
can any one please tell me that what is electron confinement and quantum confinement? i google it but not able to understand that in actual what it is?...