When comparing a field name with a column name of more than one word

From: Fox (@)
Date: 02/13/03


From: "Fox" <fox @ connexions .net>
Date: Thu, 13 Feb 2003 16:05:24 -0500


Do I need a special syntax for a comparison such as

WHERE PromoterName = ThisPromoterName

When ThisPromoterName is both a first and last name ?
i.e. ThisPromoterName = bob smith
All exmples in my books have a single word in the comparison.
I can see that joining them with an undescore would work,
but isn't there another way ? Actually I could swear it was
alread working and that maybe I am entirley misguided
by making a different mistake which is now effecting this part
of the statement.

Fox