adding a query as parameter using 'contains' logic

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.

What should it be?

Help much appreciated,

An 'over-his-head' Texas Tonie

Texas Tonie,

If you want a range of values, look at the BETWEEN operator. For character
strings, however, the whole issue of collation and sort order needs to be
considered when defining what is between.

For your example problem, assuming that the 'number' is actually a character
string (not some sort of numeric datatype) and that the number may have
leading spaces, then you could use:

DECLARE @Value = ' 12345'

SELECT @Value WHERE LTRIM(@Value) LIKE '12345%'

FWIW,
RLF

"Texas Tonie" wrote in message

> 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.
>
> What should it be?
>
> Help much appreciated,
>
> An 'over-his-head' Texas Tonie