Postcode splitting at whitespace

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

padmakumar_pga Right there with Babe Points: 766 More actions · Answer 1

Hi

To return all start with AB12

u can use like 'AB12%' or if u need only with space then like 'AB12 %'

Simon Martin SSC-Addicted Points: 468 More actions · Answer 2

Hi,

Have tried LIKE

However its throwing back an error "converting the varchar value 'NG19 8DK' to a column of data type int"

The column is varchar so why is it trying to convert it at all?

Sharing knowledge saves valuable time!
Simon Martin

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 3

SELECT a.*

FROM order_details od

INNER JOIN orders o ON od.order_number = o.order_number

INNER JOIN addresses a ON od.address_number = a.address_number

WHERE od.product = 'KIT'

AND o.cancellation_reason IS NULL

AND (a.postcode LIKE 'NN10%'

OR a.postcode LIKE 'RH17%')

Simon Martin SSC-Addicted Points: 468 More actions · Answer 4

Chris

Many thanks - that's sorted it out. And like all great solutions blindingly simple when you stop and think about it!

Sharing knowledge saves valuable time!
Simon Martin

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 5

No problem, glad it helped. Those solutions are often the hardest to find.