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-09 : 07:47:14
|
| RTRIM is not removing the speaces. And when I usedSTUFF(field, LEN(field), 1, '') it worked fine. But the values which does not have space it removes the last character. How I may overcome this problem please tell me.I am picking table_name from a field that stores table_name. I am dynamically generating the SQL statement. but when I pick the table_name and concatenate it with a field_name like thistable_name.field_name it does not do this while it make it something like thisselect * from table where table .field_name = 'ABC'i want to remove these spaces. |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-08-09 : 09:02:52
|
| This is the 3rd time you have posted this query.......please keep all discussions on a problem on the original post....it helps us to track the previous answers given.re this problem: post your code......your description of the problem is too vague/short to enable us to help you solve it. looking at the code should short-cut all this hassle...also you didn't answer my questions....http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=38373 |
 |
|
|
|
|
|
SPACE PROBLEM