Go4Expert - View Single Post - JDBC-ODBC Bridge Query Problems with "LIKE" clause

OpenLink

The most likely problem is your LIKE wildcard.

Instead of

Code:

SELECT * FROM tblNAmes WHERE strFirstName LIKE '*a*' ORDER BY strFirstName;

try

Code:

SELECT * FROM tblNAmes WHERE strFirstName LIKE '%a%' ORDER BY strFirstName;

.

Hope that helps,

Ted
OpenLink Software
Technical Support

OpenLink Newbie Member
7Aug2010,00:09
	The most likely problem is your `LIKE` wildcard. Instead of Code: SELECT * FROM tblNAmes WHERE strFirstName *LIKE 'a'* ORDER BY strFirstName; try Code: SELECT * FROM tblNAmes WHERE strFirstName LIKE '%a%' ORDER BY strFirstName; . Hope that helps, Ted OpenLink Software Technical Support