hi,
i got a user database with a field which contains several attributes formatted like ' 1 1 1 1'
1 means available, and the position referers to the attribute (eg. position 3 means telephone)
i'd like to be able to do a selection like:
get all with phone + fax
the query would be (where mid(attr,3,1) ='1' and mid(attr,5,1)='1')
ok - but now the problem.
i have a stored procedure and need a variable option to feed it with the attributes required.
eg.
procedure1:
get all with phone + fax + email
-> result -> procedure2
i can't set up usual parameters as i need to have optional parameters.
how can this be done?
thanks,
.tOm
