Search for postcode using SQL

Chris100682 | 15:12 Thu 23rd Nov 2006 | Technology

4 Answers

Hi,
I'm trying to write a query to search for a post code in SQL. The only problem is.... the Post code has a space.

Chris

Topfield Hard Disk Recorder

Windows Media help!!

Answers

1 to 4 of 4

Best Answer

No best answer has yet been selected by Chris100682. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

Chris100682

Question Author

Sorry should of said - there is a number of different postcodes in my table of data, some have spaces some don't!!

OBonio

What database is it?

Chris100682

Question Author

It's Informix.

rojash

Just a guess:

Select * from Address WHERE ThisPostcode like Replace(' ' with '' in Postcode)

(This assumes that you have already removed spaces from the user-entered "ThisPostcode", so now you need ro remove spaces from the Column (Postcode) on which you are searching).

1 to 4 of 4

Do you know the answer?