SQL Column Value Within string

Question

I Have a string below

100Pipers22WoodfieldRoadBlackpoolFY16AX

I also have an address table on where i want to cross reference the postcode column to see if the value exists in the above string. Column value would be FY16AX which is visible in the string.

I cant seem to get a match.

Tag your question with the database you are using. Also, provide the code you have. — Gordon Linoff
– Gordon Linoff, Commented Nov 20, 2018 at 12:08

Gordon Linoff · Accepted Answer · 2018-11-20 12:09:41Z

1

If I understand correctly, you can use like. In standard SQL, this would look like:

where string like '%' || postcode

The || is the string concatenation operator. Some databases have their own operators or functions for this functionality.

answered Nov 20, 2018 at 12:09

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ash Over a year ago

Might want to consider case too - e.g. UPPER or LOWER on both your string and search-term (in this case postcode)

jarlh Over a year ago

@doublesidedstickytape, better to use a case insensitive collation.

level3looper · Accepted Answer · 2018-11-20 15:35:17Z

0

Declare @vString nvarchar(50)
Set @vString = '100Pipers22WoodfieldRoadBlackpoolFY16AX'

Select Count(*) From tbl_Address Where Zip = right(@vString,6)

If the select statement returns a value greater than zero, you have a match.

answered Nov 20, 2018 at 15:35

level3looper

1,0411 gold badge8 silver badges10 bronze badges

Collectives™ on Stack Overflow

SQL Column Value Within string

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related