How to write inline like operator with Variable value

Question

I have the following query, can you please suggest me what is wrong with this, its never entering inside the IF block, even though data is present in a table.

 DECLARE @AccountNumber NVARCHAR(50) ='54654654'

 IF Exists( Select TOP 1 1 FROM [dbo].[CheckRecords] where DetailRecord like '% ' + @AccountNumber +' %')
 BEGIN
     Print 'Hello' + @AccountNumber 
 END

You can try DECLARE @AccountNumber NVARCHAR(50) ='% 54654654 %' — Fabio
– Fabio, Commented Jun 10, 2021 at 2:58
Infact I tried that , its still not entering inside IF Block — Kumas
– Kumas, Commented Jun 10, 2021 at 3:04
You need to show some sample data from the table because the logic is right... that is assuming your search is surrounded by spaces as shown? You can remove top 1 though because exists doesn't require a single record. — Dale K
– Dale K, Commented Jun 10, 2021 at 3:41

shohel · Accepted Answer · 2021-06-10 03:48:26Z

1

 DECLARE @AccountNumber NVARCHAR(50) ='54654654'
 IF Exists( Select TOP 1 1 FROM [dbo].[CheckRecords] 
 where DetailRecord like '%'  + @AccountNumber +'%')
     BEGIN
         Print 'Hello ' + @AccountNumber 
     END

try this it will work. it was not working because of extra space.

answered Jun 10, 2021 at 3:48

shohel

442 bronze badges

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

2 Comments

Kumas Over a year ago

Thank you for the response, it worked but above query taking almost 50 seconds to complete , Can you please suggest me if there is any better way of writing same logic ?

shohel Over a year ago

replace of exists , you can use not null function

Collectives™ on Stack Overflow

How to write inline like operator with Variable value

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related