This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |
| tech-notes:sql [2022/12/21 14:06] – gerardorourke | tech-notes:sql [2022/12/21 14:06] (current) – [SUBSTRING and CHARINDEX] gerardorourke |
|---|
| *https://docs.microsoft.com/en-us/sql/t-sql/language-elements/exists-transact-sql?view=sql-server-ver15 | *https://docs.microsoft.com/en-us/sql/t-sql/language-elements/exists-transact-sql?view=sql-server-ver15 |
| |
| ==== SUBSTRING and CHARINDEX ==== | ===== SUBSTRING and CHARINDEX ===== |
| |
| Here we have a column 'myColumn' with a comma separated value of (for example) 'apples,bananas' and we want FirstVariable = 'apples' and SecondVariable = 'bananas' | Here we have a column 'myColumn' with a comma separated value of (for example) 'apples,bananas' and we want FirstVariable = 'apples' and SecondVariable = 'bananas' |