Remove spaces from string and select using that string in sql server

Question

In SQL Server, I am trying to select some of the records using a string which has space so I trim and use but something is wrong please correct me where something is missed by me.

SELECT * FROM projects where str_id=ltrim(rtrim('   artf130 ')) --- No rows selected
SELECT * FROM projects where str_id='artf130' -- one row selected

Update: I copied the first line from google spread sheet.

Hello! Maybe take a look in here: http://stackoverflow.com/questions/14211346/how-to-remove-white-space-characters-from-a-string-in-sql-server And maybe give the answer a vote up. — Cataklysim, Feb 09 '17 at 13:13
@sunleo "so I trim and use but something is wrong please correct me" what is that 'something'? show us some sample data. — PowerStar, Feb 09 '17 at 13:30
When I copied from google spread sheet some in-visible characters are there and, ltrim and rtrim could not remove them. — sunleo, Feb 09 '17 at 13:42

score 2 · Accepted Answer · edited May 23 '17 at 12:09

2

Maybe that was my bad. People keep helping. I think my comment was enough, cause I linked to a very similar problem, which got a answer. So here for everyone:

You can see the answer to that question here.

edited May 23 '17 at 12:09

Community

1
1

answered Feb 09 '17 at 13:39

Cataklysim

637
6
21

Remove spaces from string and select using that string in sql server

1 Answers1