SQL Statement

[Anonymous]

Hello to all !
Aim trying to make a “Zoom goto” with street names, but as you imagines the same street name exists in more than one city.
The source table is from a shp and it includes street name and the city name, but when I try to make the SQL statement and select street_name, city_name and Feature_GEOM, gives me an error, saying that “contains an invalid number of columns”.
The SQL statement that I use is:

select street_nam, city_nam, FEATURE_GEOM
from streets
where street_nam like '%%%s%%%' order by street_nam

well, what I ask is that is some way to make a concatenation for two of the columns (street_nam and city_nam), or some other way.
I hope I made my self understood.
Thank you all in advanced

Diogo David