SQL: Translate
From: Timothy R. Ayers <ayers_at_shark.micro.umn.edu>
Date: 15 Apr 92 16:59:53 GMT
Message-ID: <1992Apr15.165953.1542_at_news2.cis.umn.edu>
Date: 15 Apr 92 16:59:53 GMT
Message-ID: <1992Apr15.165953.1542_at_news2.cis.umn.edu>
I am trying to update an address line in the database where someone
entered an "*" or "**" at the end of each mailbox number. So the records
look like this: 2076**
I would like to remove the "*" and replace it with spaces or null.
Someone suggested using the TRANSLATE function, but I can't find
much documentation on it. Does anyone have any suggestions how to make
this function work.
Thanx in advance for your help.
1367*
Judi Received on Wed Apr 15 1992 - 18:59:53 CEST