I am using dynamic permissions with these key fields
username: robert
password: password
account: CA12345
all records are displayed where the users account = the account in my orderheader in this case CA12345
works great
what i would like to do is is create a user to be able to see all account that are like CA123
the sql for the above would be "select from orderheader where account = 'CA12345'
the sql for the change would be "select from orderheader where account like 'CA123%'
I have edited the above user and set the account = CA123% but that returns no records <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=8645&image=1&table=forumtopics' class='bbcemoticon' alt='<<' />
Does anyone know how to accomplish this.
