Is there a *

[EscapeUK]

Is there a * facility for numbers.

I have a search that looks at a table of numbers. Sometimes they can enter a value sometimes but sometimes if they want they don't have to.

Any ideas

 

[alpine]

using convert function convert the numeric column to varchar and then use the *

 

[mfairchild]

I'm not sure exactly what you are trying to do but, if your search is using a parameter to a stored procedure, use "or".

Example:
Create MySearchProcedure @Integer_Parameter integer = Null
AS

SELECT Integer_Column
FROM TableSearchingIn
WHERE (Integer_Column = @Integer_Parameter
or @Integer_Parameter is Null)

Or did I miss the point of the question?

 

[EscapeUK]

you both got the question correct, which one of the 2 responces would be faster?

 

[EscapeUK]

How do i use the convert in my select statement

 

[EscapeUK]

Sorry just been looking at my app and I would rather not use the 'or' option as there are 5 parameters being used that might have null