Yak Posting Veteran
Posted - 02/19/2013 : 11:17:02
Im looking to see if I can make a paramater dependenet on another in SQL (AND SSRS)
Basicaly we currently have a look up where people put part of a name in and it takes all of them and searches
Contact_Name LIKE '%' + @BrokerLookup + '%'
so if it was like nic
it would pick out nick, nicholas, nic from the contact name
what I then want is a second paramater that goes okay heres all the contact names liek nic, now in ssrs I want just nick and nicholas and to exclude nic...
how would I do this in SQL? I think SSRS bit is just a case of adding a paramater which is hidden until someone types in something in to first paramater am i right?
Nic, Nick, NIcholas :)