postcode search

[moleboy]

Anyone,

I'm trying to search my database using the first part of the postcode to return records in an sp. The problem is when i put eh6, i get all eh6 plus eh61, eh64, etc. And when i use just eh I get no recods at all. I cant really use left due to the fact that some postcodes are only two characters like w1.

Can anyone show me any code to search for postcodes?

Cheers

Moley

 

[ClaireHCM]

For field = eh6
ex.
select * from mytable where left(field,3)='eh64'

For field started with 'eh'
ex.
select * from mytable where field like 'eh%'

Maybe not right,can you show how your coding look like?

 

[rsnorris]

I use this stored proc to select specific postcodes based on the first part. I believe it will fit your requirements.

CREATE PROC dbo.spPostcodePart
	@FirstPart varchar(4)
AS

DECLARE @FirstPartLen INT
SET @FirstPartLen = LEN(@FirstPart)

SELECT * FROM MyTable
WHERE LEFT(POSTCODE,@FirstPartLen+1)=@FirstPart+' '