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 bkrike 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 ndjs
-
Problem With Like
Sunaj - I've tried the crude "SELECT * from MyTable Where Name like '%-t%'", con, adOpenStatic, adLockOptimistic but still no records are returned ! Whereas you were succesful. Could it be anything to do with the setup? I'm using ADO looking up an Acesss.mdb- ndjs
- Post #8
- Forum: Visual Basic (Classic)
-
Problem With Like
Sunaj - I'm sorry about the ambiguity, but without trying to type in reams of tedious numbers I was trying to demonstrate that my code was unable to find the last letter(s) of the string whatever it is ie; If QryString = "T01" 3 records are returned = "-1903" 2...- ndjs
- Post #5
- Forum: Visual Basic (Classic)
-
Problem With Like
Consider the following numbers : M01T01-1903-0689-1 M01T01-1903-0689-2 M01T01-1906-0788-t et al If I use SELECT * FROM Component Where TypRef LIKE '"& "%" & QryString & "%" '" I can find any combination of letters or numbers except when the QryString =...- ndjs
- Thread
- Replies: 7
- Forum: Visual Basic (Classic)
