Re: adding a query as parameter using 'contains' logic
- From: Hugo Kornelis <hugo@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 16 Nov 2007 00:47:48 +0100
On Tue, 13 Nov 2007 12:53:02 -0800, Texas Tonie wrote:
Hello,
Setting parameter ranges for a query is very useful.
How can I specify : begins with ...... and make that a parameter (in this
case first 5 digits of a project name)?
Liek '%[parameter3]%' does not work.
Hi Texas Tonie,
Try
LIKE @parameter3 + '%'
--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
.
- Prev by Date: Re: Cross tab based on DateDIFF
- Next by Date: Re: Counting in SQL Queries
- Previous by thread: Re: adding a query as parameter using 'contains' logic
- Next by thread: Re: Cross tab based on DateDIFF
- Index(es):
