> On Mar 2, 2018, at 5:41 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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 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" 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 a boost! ;-) >> Thanks, >> Dale. > > > -- > Adrian Klaver > adrian.klaver@xxxxxxxxxxx > Use the tilda, Luke. filename ~ ‘^D:’
