I am wanting to search a PostGIS database using a Contains or Like query to search strings for a partial match.
My last attempt is proprietor_1 LIKE '@Value(Name)'
I also tried CONTAINS(proprietor_1, '@Value(Name)')
proprietor_1 is in my PostGIS
Name is in my routine
Any assistance with queries would be great.
Unless you already have the "%" wildcard character the attribute, you probably want to do as follows for the partial match:
proprietor_1 LIKE '%@Value(Name)%'
Use:
"proprietor_1" like '@Value(Name)'
Also, read this article on Performing spatial queries on database tables Performing spatial queries on database tables using the FeatureReader (safe.com)