Query.Where clause

WilliamMeredith

The below statement functions fine in a mapserver query: 

query.where = "STRU_NAME = '" + structure+ "'";

I'd like to switch the " = " to a like statement.  I can't seem to get this statement to return any data:

query.where = "STRU_NAME like '" + structure+"'";  

Any suggestions?  I'm fairly new to development, probably something easy.

rscheitlin

William,

  Sorry I had my % in the wrong place (% then single quote).

query.where = "STRU_NAME like '" + structure+ "%'";