> On Mar 2, 2018, at 5:41 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>
>> On 03/02/2018 04:36 PM, Dale Seaburg wrote:
>> 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
inthe WHERE clause, to look at the first 2 characters in the Image_Filename column? What is the correct SQL syntax for
lookingat just a portion of a column?
>
> SELECT "Image_Filename" FROM "Instruments" WHERE "ImageFilename" LIKE 'D:%';
>
> If you want case insensitive then ILIKE. For more info:
> https://www.postgresql.org/docs/10/static/functions-matching.html#FUNCTIONS-LIKE
>
>> 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
aboost! ;-)
>> Thanks,
>> Dale.
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
Use the tilda, Luke.
filename ~ ‘^D:’