From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Dale Seaburg <kg5lt(at)verizon(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: SQL syntax |
Date: | 2018-03-03 00:41:35 |
Message-ID: | 8be3c025-ebf8-59f4-1ab8-22206947e078@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Ken Tanzer | 2018-03-03 01:01:14 | Re: SQL syntax |
Previous Message | Dale Seaburg | 2018-03-03 00:36:57 | SQL syntax |