Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Colt21

  1. Colt21

    Pass variable in a LIKE statement.

    Thank you. Worked perfectly. Once I got that I just had to change my data type from int to varchar. Thanks again.
  2. Colt21

    Pass variable in a LIKE statement.

    Can you please help with something I thought I could simply find, but have not. How can I use a variable in a LIKE statement? I tried: SELECT * FROM TABLE WHERE COLUMN LIKE '%@VARIABLE%' but it seems it is looking at the variable as text instead of variable. I am using MS SQL Express Thanks
See more

Part and Inventory Search

Back
Top