How to fix like statement?

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Michael L John One Orange Chip Points: 27056 More actions · Answer 1

What is the error you are getting? That may help.

Also, it looks as if you are trying to use Dynamic SQL

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

adonetok SSCrazy Eights Points: 8395 More actions · Answer 2

Error:

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near '000'.

Msg 105, Level 15, State 1, Line 3

Unclosed quotation mark after the character string '''.

Michael L John One Orange Chip Points: 27056 More actions · Answer 3

You are concatenating the string incorrectly.

Change the last line to:

where CLAIMNO like Convert(VARCHAR(20), Getdate(), 112) +'80' + Right('000' + @operator, 3) + '%'

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

adonetok SSCrazy Eights Points: 8395 More actions · Answer 4

SSCrazy Eights

Points: 8395

March 4, 2014 at 10:12 am

Thank you. It works now

Sean Lange SSC Guru Points: 286590 More actions · Answer 5

This is a classic example of why you shouldn't shove multiple data elements into a single column. It is a serious PITA to work with.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.