|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Minimize the cost of deploying database applications. Advantage Database Server or Microsoft SQL Server – Which One is Right for You? Learn now! |
|
#1
September 16th, 2003, 03:37 PM
|
|||
|
|||
truncating string
Hello,
I am trying to delete some unreadable characters from one of the database fields called "state". I have used the rtrim command as rtrim(state) but it does not work. But when I manually go to each record I see that there is a space right after the state. e.g. 'NJ' actually is 'NJ ' same is the case with some other fields in the database and rtrim does not work with them. Any one got a clue?? Thanks URL
|
|
#2
September 17th, 2003, 02:43 AM
|
||||
|
||||
|
how exactly are you doing this? try this query : "UPDATE [your_table] SET state = RTRIM(state)"
that should do it.
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > truncating string |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
