With both subs you must enter the values as you would write them into a sql string i.e. 'mustsurroundstrings'
I'm rather new at VB.Net and SQL but these work for me and are seem pretty efficient. If anyone has a way to improve on them or finds a flaw in them please feel free to email me [snipped].