given a cell in column TOPIC, how do I write a select where the X position of a character in a cell results in a 1? The cell is in nvarchar and always contains a string of 1's and zeroes
For example, consider a row of data:
Select NAME from DBO.Workshops where Title = 'MyTitle' AND <the 4th character of TOPIC = '1'>
How do I write the part
'the 4th character of TOPIC = '1'