Like"*" passed in a function to show all records

[byterbit]

I have a function in a module ( a very simple one that works well :

Function GetMyVariable()


GetMyVariable = VCODE
End Function

)
that I use to pass parameters into queries .
Typically vcode would carry a "code" to show a fraction of records. In the query itself the criteria reads: GetMyVariable()


I now need to tell the query to show ALL records , and I pass in: Like"*"
It blows up, shows no records !

[Rixxe]

Well if you think:

say you have a code '00001'
the function and query i guess would say:

SELECT *
FROM TableA
WHERE code = VCODE (Is basically saying '00001' = 'Like"*"')

That's not going to work as '00001' is not equal to 'like "*"'. This is my guess as to the issue.
I'd recommend you show everyone the whole query including SQL code etc so we can have a look.

Personnally i'd change your function/query to allow for null values.


If VCODE != null
Do Something
else
Do nothing