>Hi Trey,
>
>>Why not store NULL to that field instead of Chr(0)?
>>That works across all databases.
>
>We can't use NULL, because each character in the string represents a different module.
>
>e.g. To code a user as having no rights to module 3, the third character in the string would be chr(0). The user could still have all rights to all other modules.
>
>Best.
>
>Matt.

I don't know if CHR(0) "should" work or not in the scenario you have created since I have not tried this, but assuming CHR(0) simply will not work, could you substitute a different character for storage and manipulation purposes then strip out the character for display? Or is your scenario to complex for this type of solution?

Bill