Re: SQL syntax

2018-03-02 Thread Rob Sargent
> On Mar 2, 2018, at 5:41 PM, Adrian Klaver 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 W

Re: SQL syntax

2018-03-02 Thread Tom Lane
Adrian Klaver writes: > On 03/02/2018 04:36 PM, Dale Seaburg wrote: >> 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 >> co

Re: SQL syntax

2018-03-02 Thread Ken Tanzer
On Fri, Mar 2, 2018 at 4:41 PM, Adrian Klaver 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 t

Re: SQL syntax

2018-03-02 Thread Adrian Klaver
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