CODEWITHSUNDEEP
sqlsql-servert-sqlsql-like
Cll
Cll

Reputation: 89

How to use Ltrim Rtrim with 'like operator'

I want to use functions in like operator.

select * from LG_211_CLCARD where DEFINITION_ like '%LTRIM(RTRIM('test  '))%'

Upvotes: 1

Views: 1344

Answers (1)

Salman Arshad
Salman Arshad

Reputation: 272256

I suppose you want this:

SELECT *
FROM LG_211_CLCARD
WHERE DEFINITION_ like CONCAT('%', LTRIM(RTRIM('   test   ')), '%')

Upvotes: 3

Related Questions