ustomerreferredby, customerstateabbr, customerstreet1, customerstreet2,
>> customersuffix, customertitle, customerworkphone, customerworkphoneext,
>> customerzip FROM lanemanager.customers WHERE (customerlastname ILIKE $1
>> ||
>> '%')
>> $$
>> LANGUAGE SQL;
itial, customerphone,
customerreferredby, customerstateabbr, customerstreet1, customerstreet2,
customersuffix, customertitle, customerworkphone, customerworkphoneext,
customerzip FROM lanemanager.customers WHERE (customerlastname ILIKE || '%')
landsharkdaddy wrote:
>
> I have a qu
it told me that the + could not be used. Not sure the exact message but
I will check again tomorrow and see what it was and post the results.
Scott Marlowe-2 wrote:
>
> On Sun, Apr 26, 2009 at 6:21 PM, landsharkdaddy
> wrote:
>>
>> I have a query that works on SQL Server t
I have a query that works on SQL Server to return customers that contain the
string entered by the user by accepting parameters and using the LIKE
keyword. I would like to move this to postgreSQL but I'm just not sure how
to get it done. This is the query
SELECT * FROM Customers WHERE FirstName
