Query where clause type conversion

TedChapin

I want to do a type conversion and a concatenation in a query where clause.  I have street number as a esriFieldTypeInteger and street name as a esriFieldTypeString.  I want to search for "5 Main Street" as a single search term.  If the street number were string, I could use this:
CONCAT(street_num, CONCAT(' ', street_name)) = '5 Main Street'
But the numeric field type is causing difficulty.  I've tried CAST and CONVERT to varchar, nvarchar, text, but it doesn't work.

Any ideas?

Ted Chapin

JenniferNery

Is your Query.Where clause checking against two different fields? If so, I think you need to keep the search fields separate.

For example:
Where = Street_Number = 5 and Street_Name = 'Main Street'

int streetNumber;
string streetName;
query.Where = string.Format("StreetNumber = {0} and Street_Name = '{1}'", streetNumber, streetName);