Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

syntax error

3 Posts 2 Posters 0 Views 1 Watching

P Offline
P Offline
peteyshrew

wrote on last edited by

#1

can anyone tell me how to correct this SQL Query "SELECT DISTINCT * from Pupils WHERE Surname LIKE% '" & tbSearch.Text & "' " Syntax error in query expression 'Surname LIKE% 'Lowndes''. trying to search for data using tbSearch as the search criteria
A 1 Reply Last reply

0
P peteyshrew

can anyone tell me how to correct this SQL Query "SELECT DISTINCT * from Pupils WHERE Surname LIKE% '" & tbSearch.Text & "' " Syntax error in query expression 'Surname LIKE% 'Lowndes''. trying to search for data using tbSearch as the search criteria
A Offline
A Offline
andyharman

wrote on last edited by

#2

"SELECT DISTINCT * from Pupils WHERE Surname LIKE '%" & tbSearch.Text & "' "
P 1 Reply Last reply

0
A andyharman

"SELECT DISTINCT * from Pupils WHERE Surname LIKE '%" & tbSearch.Text & "' "
P Offline
P Offline
peteyshrew

wrote on last edited by

#3

thank you
1 Reply Last reply

0

Log in to reply