sql server - Use like in T-SQl to search for words separated by an unknown number of spaces -


i have query:

select * table column '%firstword[something]secondword[something]thirdword%'

what replace [something] match unknown number of spaces?

edited add: % not work matches character, not spaces.

perhaps optimistically assuming "unknown number" includes zero.

select *  table  replace(column_name,' ','') '%firstwordsecondwordthirdword%' 

Comments

Popular posts from this blog

List<T>().Add problem C# -

Javascript natural sort array/object and maintain index association -