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: stackoverflow.com/questions/14211346/… And maybe give the answer a vote up. — Cataklysim
– Cataklysim, Commented Feb 9, 2017 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
– PowerStar, Commented Feb 9, 2017 at 13:30
When I copied from google spread sheet some in-visible characters are there and, ltrim and rtrim could not remove them. — Jericho
– Jericho, Commented Feb 9, 2017 at 13:42

Community · Accepted Answer · 2017-05-23 12:09:05Z

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, 2017 at 12:09

CommunityBot

11 silver badge

answered Feb 9, 2017 at 13:39

Cataklysim

6871 gold badge8 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related