DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=xI+kXeHNb8YM6YpAe6WtAaVqQxR1VvXUsrUNlpieH2J/4IrWlHUazwjpTMr1UL54aA
	DW0CKVjN6SNq6lS+I4ZpDGrNyS0OwkOU5zvF5i+ngqHR7GY8H8nERk1trCRecD1Voc4q
	tMuaF+Z3rO1lmashWad/Yll6EJ+Hx618lIKNc=
MIME-Version: 1.0
In-Reply-To: <23248274.post@talk.nabble.com>
References: <23248274.post@talk.nabble.com>
Date: Sun, 26 Apr 2009 22:54:17 -0600
Message-ID: <dcc563d10904262154n19dd9f77pe81fe23eebeeac2e@mail.gmail.com>
Subject: Re: Query with Parameters and Wildcards
From: Scott Marlowe <scott.marlowe@gmail.com>
To: landsharkdaddy <ldodd@landsharksoftware.com>
Cc: pgsql-sql@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

On Sun, Apr 26, 2009 at 6:21 PM, landsharkdaddy
<ldodd@landsharksoftware.com> 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. 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.

Have you tried:

SELECT * FROM Customers WHERE FirstName LIKE 'custfirst%';

What does the @ do in sql server?