SQL select where like using query string

Question

if i have these two complicated query strings

 ALM_frmTopAlarmHistoryReport.aspx?strAlarmConnection=AlarmSystem

AND

 http://1.1.4.1/xyz/ALM_frmAlarmHistoryReport.aspx?ViewPDF=
 1&dtmStartDate={0}&dtmEndDate={1}& + '&lngAlarmGroup=' + 
 $('#ddlAlarmGroup').val() + '&lngProcessor=' + $('#ddlProcessor').val() + 
 '&intCategory=' + $('#ddlCategory').val()

how can i excuete a select WHERE LIKE condition i tried

 SELECT * FROM [tablename] WHERE string1 LIKE '%string2%'

and i got the following error

   Msg 103, Level 15, State 4, Line 1
   The identifier that starts with'%string2 ' is too long. Maximum length is 128.

any help will be very welcome thanks in advance

Gordon Linoff · Accepted Answer · 2012-07-24 15:41:32Z

1

Use locate or instr instead:

select *
from tablename
where instr(string2, string1)  > 0

answered Jul 24, 2012 at 15:41

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

Collectives™ on Stack Overflow

SQL select where like using query string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related