Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
real_pearl
Posting Yak Master
106 Posts |
 Posted - 2004-08-06 : 06:36:25
|
| If I have a string 'P9240502_001 ' in a variable.and want to get like this 'P9240502_001', what will I have to do? |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2004-08-06 : 06:37:47
|
| SELECT RTRIM(Field) FROM table--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
 |
|
|
real_pearl
Posting Yak Master
106 Posts |
Posted - 2004-08-06 : 06:49:15
|
| RTRIM did not work. I usedSELECT STUFF(Field, LEN(Field), 1, '') FROM Table |
|
|
|
|
|
|
SPACES