update data in a column 1

[cduncan]

Its been a good while since I've written SQL and I need to update a column of SSN that do not have dashes to contain dashes. The field is a varchar so I need to go from '123456789' to '123-45-6789'. Any help greatly appreciated!!!

 

[fredericofonseca]

Why do you need to update the field? If you need to display it or print it with that format then you can always format it during the select itself.

Anyway you would do a update tbl set fld = "expression" where expression will depend on your DB.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[cduncan]

select number from ems.technician t
where last_name = 'Bosch' [the result is 056649129]

to change it to 056-64-9129...

update ems.technician t
set t.number = (%%% + '-' + %% + '-' + %%%%) where last_name = 'Bosch'

?????

What am I doing wrong? If I could only import it from the text file I did it successfully with from Excel!!!

 

[fredericofonseca]

what db are you using?

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[cduncan]

IBM DB2

 

[PruSQLer]

Set t.number = substr(ss,1,3) || '-' || substr(ss,4,2) || '-' || substr(ss,6,4)

should work