WHERE $postal = first 4 chars of Postalcity
Posted: Thu Feb 17, 2005 4:15 pm
Hello Folks,
I have a field ' postalcity ' where postal code and city is stored and separted by a space
exemple
1000 Berlin
2000 Munich
1000 Berlin
2500 Frankfurt
Now I need a query , for exemple to get me all the records with postal c greater than 2000
something like
SELECT * from table WHERE first4charsof (postalcity)>='1000';
Can anybody help me with this query?
Thanks in Advance
I have a field ' postalcity ' where postal code and city is stored and separted by a space
exemple
1000 Berlin
2000 Munich
1000 Berlin
2500 Frankfurt
Now I need a query , for exemple to get me all the records with postal c greater than 2000
something like
SELECT * from table WHERE first4charsof (postalcity)>='1000';
Can anybody help me with this query?
Thanks in Advance