Selecting all from a row if variable is undefined?

[TJMAudio]

Say I have an INT row that contains numbers 0 through 11.  If the user does not define a number, I want it to pull from the row, no matter what it contains.  Sorry if I am explaining this unclearly.  Anyways, would I just do it like this:

 

SELECT * FROM table WHERE $variable LIKE '%'

 

Or is there some other way of doing it?

[blirette]

If your default value for the row is '' then you could say something like WHERE rowname >= 0 AND rowname <= 11

 

It should evade all other thing such as '' fields.

[fenway]

You should be building your WHERE clause dynamically.