My mind is drawing a blank. Not sure where to go to find the answer.
Here is the statement in C#:
sSQL = "SELECT \"Image_Filename\" FROM \"Instruments\" WHERE ";
To finish off the WHERE clause, I need to look at the first 2 letters,
like "D:". My question is how do I specify in the WHERE clause, to look
at the first 2 characters in the Image_Filename column? What is the
correct SQL syntax for looking at just a portion of a column?
I feel so dumb... This can't be that hard, but I am exhausted and
running out of ideas. I need someone to give me a boost! ;-)