-
script to remove a character from the data in a field
We have a table called Patient with a field Sin (which is their Social Security Number). Some people put the SSN in with the dashes and some with out. I need to go through the table and remove the dashes, so all the SSN will not have dashes. Can anyone help me out with this?
-
I got it, this worked:
update patient set "Sin"= REPLACE ("Sin",'-','') where "Sin" like '%-%'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|