paul 17028 (5/3/2015)
HiI am trying to alter this SQL to search for exact match only, non case sensitive. I have been trying for over an hour without result
Thank you
strSQL = "SELECT N_image_number, N_image_name, N_image_desc, N_available, N_i_size, N_image_th, N_image " _
& "FROM tblart " _
& "WHERE N_image_desc LIKE '% " & Replace(strSearch, "'", "''") & "%' " _
& "OR N_image_name LIKE '%" & Replace(strSearch, "'", "''") & "%' " _
& "OR N_image_number LIKE '" & Replace(strSearch, "'", "''") & "' " _
& "ORDER BY N_image_order ASC;"
Quick question, can you post the ddl ( create table) and sample data in the form of an insert statement?
😎