I have not tried that but I will in the morning. The @ in SQL is used to
indicate a parameter passed to the query. In PostgreSQL it seems that the :
is the same as the @ in SQL Server. I tried something like:
SELECT * FROM Customers WHERE FirstName LIKE :custfirst + '%';
And it told me th
On Sun, Apr 26, 2009 at 6:21 PM, landsharkdaddy
wrote:
>
> 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 d
On Apr 26, 2009, at 7:21 PM, landsharkdaddy wrote:
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.
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
