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!

  • Congratulations Chriss Miller 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 bluelake367

  1. bluelake367

    Search: Wildcards

    Figured it out -- thanks for the help and a bit of playing on my own: SELECT * FROM MAC WHERE RequestedBy LIKE '%MMColParam%' I was missing the LIKE and then in the default value for the variable you put % Thanks for putting me on the right track.
  2. bluelake367

    Search: Wildcards

    SELECT * FROM MAC WHERE RequestedBy = '%MMColParam%' Alright the SQL Statement looks like this. Under the box for "variables" in UltraDev it says Name Default Value Runtime value MMColParam What do I put here? Request.QueryString("RequestedBy") Just putting the %...
  3. bluelake367

    Search: Wildcards

    I'm new to this and never been able to get this to work. I have a text box for a search. Where I want a user to search for their request by their name -- but I want to allow them to put only a partial name or just their last name, not to be a literal string search match. So using the simple...

Part and Inventory Search

Back
Top