MS SQL - find out if a field exists within another

Question

I have a table that, among its columns, has two particular char columns: "Code" and "Obs".

For example:

Column1	Code	Obs
aaa	123	This customer's code is 123

How do I find this record, based on the fact that the info on column "Code" is present in the info on column "Obs"?

Mureinik · Accepted Answer · 2021-09-13 18:02:00Z

1

One option is to use charindex:

SELECT *
FROM   mytable
WHERE  CHARINDEX(code, obs) > 0

answered Sep 13, 2021 at 18:02

Mureinik

316k54 gold badges400 silver badges405 bronze badges

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

Comments

JoeDumars · Accepted Answer · 2021-09-16 15:00:17Z

0

Is there a reason this is happening?

SELECT num1, num2, CHARINDEX(num1, num2) as charindex
FROM   mytable

answered Sep 16, 2021 at 15:00

JoeDumars

233 bronze badges