Query - Find A Alphabetic Charther

Morning/Afternoon

Hope you can help me, am current working on ISIN numbers it doesn’t matter if you don't know what they are.

Now I have a table that is like this

table name = tDocISIN
col1 = LID(int)
col2 = sISIN(varchar(50))
col3 = lDocumentId(int)

Which has sample data like this

84237USX7318VAA4543997395
92579USO45167AR4544021575
84244USY63651114644025820
84243USY63651AA4544025820
113633USP51225AA1144028865
92846USG36912AG1344029240
92847US359860AG8444029240

Now I want to run a select query that will only bring the ones that have ‘CA’ or ‘US’ as the first two characters.

I can do that by running this:

select * from tDocISIN
where sISIN like 'CA%'or sISIN like 'US%'

But my other where clause I want to add is only bring back the ones that have CA or US as the first two characters and any other character after the first two or in the rest on the string.

So US7636516745 is an ISIN I don’t want to bring back and US763TY16745 is an ISIN I do want to bring back.

The character that does exist after the first two characters will be anywhere within the rest of the string.

Hope that is clearly explain any help would be great.

Am a total beginner. Thanks in advance.

Lee