SQL SELECT * FROM table WHERE colmn = 'value' excluding spaces

Question

Suppose there is a table Text.

Data:

[Id] [Val] 1 Hello world 2 Helloworld 3 Hello world

You need to make a query of the type SELECT * FROM Text WHERE Val = 'Helloworld'

And so that as a result there were all these three lines

Well, that is it is necessary that the query selects values without taking into account spaces (there may be a lot of them).

MSSQL

Accepted Answer · 2017-07-19T10:22:49

 SELECT * FROM Text WHERE Val like 'Hello%world'

Alex78191

3.135 1 golden mark 6 silver marks 20 bronze marks

i.imgur.com/EPQAEYZ.png Doesn't work - Tima
@Tima fixed a bug - Alex78191
Now, all is well. And you can link where about these characters can be found? - Tima
@Tima docs.microsoft.com/en-us/sql/t-sql/language-elements/… - Alex78191
Thank you very much. - Tima

|

1 answer 1