\"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 corre
e_Filename column? What is the
>> correct SQL syntax for looking at just a portion of a column?
> SELECT "Image_Filename" FROM "Instruments" WHERE "ImageFilename" LIKE 'D:%';
Another way is to use the substring() function:
SELECT "Image_Filename
\"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
rst 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?
SELECT "Image_Filename" FROM "Instruments" WHE
uestion 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! ;-)
Thanks,
Dale.
