Query with Parameters and Wildcards

From: landsharkdaddy <ldodd(at)landsharksoftware(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Query with Parameters and Wildcards
Date: 2009-04-27 00:21:35
Message-ID: 23248274.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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 LIKE @custfirst + '%';

This works great on SQL Server but not on postgreSQL. Any help would be
appreciated.
--
View this message in context: http://www.nabble.com/Query-with-Parameters-and-Wildcards-tp23248274p23248274.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ries van Twisk 2009-04-27 02:12:38 Re: Query with Parameters and Wildcards
Previous Message Leif B. Kristensen 2009-04-25 11:06:44 Multiple return values and assignment