judacoor Posted July 8, 2008 Share Posted July 8, 2008 Hi!Image a table:| Id | Name | 1 John 2 Mary 3 Joseph 4 JerryCan anybody please tell me what the sql instruction would be for making a select with possible matches for a word?........like if in my App I type "J" and it would give me:JohnJosephJerryAnd then, after the J I type an "o" to get "Jo" the result would beJohnJosephKinda like google suggest....................thanks!!! Link to comment Share on other sites More sharing options...
jeffman Posted July 8, 2008 Share Posted July 8, 2008 I'm guessing a little, but if you read this down to the LIKE condition, you might get some ideas. Just lengthen the pattern every time you get a new character. Link to comment Share on other sites More sharing options...
judacoor Posted July 8, 2008 Author Share Posted July 8, 2008 Thank you so much!That's exactly what I was looking for!Thx!!!! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.