Create a View 1

[szaunbr]

I would like to create a view of an entire table as is but with one exception. I would like to change the format of the SSN field. I would like to add the dashes into the SSN field, and select every other field in the table and create that as my view.

 

[feherke]

Hi

For that you need to enumerate all other fields or give a distinct name to the formatted field.

[b]select[/b]
[b]create view[/b] szaunbr_view [b]as[/b]
substring(ssn,1,3)||[i]'-'[/i]||substring(ssn,4,2)||[i]'-'[/i]||substring(ssn,6) [b]as[/b] ssn_formatted,*
[b]from[/b] szaunbr

Feherke.

http://rootshell.be/~feherke/