I have a database field called parents. This field can contain data in one three ways: I'll use the word parent, but I actually store names. <BR><BR>1 - Parent<BR>2 - Parent and Parent<BR>3 - Parent & Parent<BR><BR>What I would like to do is search this field and if I find and or & I would like to display the label to read Parents and then liste the field out beside the label. If no & or and is found I just want the label to read Parent. I've tried writing a simple querie using %and% or %&% and nothing has come up.