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 |
|
sureshprpt
Starting Member
33 Posts |
 Posted - 2010-08-13 : 00:42:48
|
| I download the data from the table using Query. In the table one field contain the department code. I want the description related to code. But the issue is the table contain code & desciption. The code is enter with some spaces. Ex:In the first tabel code data is"MM10" and in second table code is " MM10".if i join this field the data was not equal. If any other method to join the table or can include the data when i download the query. KIndly help me ..RegardsSureshThanks & RegardsSuresh |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-13 : 10:15:23
|
| LTRIM(code) |
 |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2010-08-13 : 10:34:15
|
quote:
Originally posted by sureshprpt
I download the data from the table using Query. In the table one field contain the department code. I want the description related to code. But the issue is the table contain code & desciption. The code is enter with some spaces. Ex:In the first tabel code data is"MM10" and in second table code is " MM10".if i join this field the data was not equal. If any other method to join the table or can include the data when i download the query. KIndly help me ..RegardsSureshThanks & RegardsSuresh
The script library is for posting working scripts. Going forward, if you have questions, please post them in the "New to SQL Server" or other appropriate forums. |
|
|
|
|
|
|
Data from Table.