When comparing a field name with a column name of more than one word
From: Fox (@)
Date: 02/13/03
- Next message: BP Margolin: "Re: This is exactly what happened to me, what's the solution?"
- Previous message: Fox: "Re: Changing passwords / Blocking SA login attempts"
- Next in thread: BP Margolin: "Re: When comparing a field name with a column name of more than one word"
- Reply: BP Margolin: "Re: When comparing a field name with a column name of more than one word"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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
- Next message: BP Margolin: "Re: This is exactly what happened to me, what's the solution?"
- Previous message: Fox: "Re: Changing passwords / Blocking SA login attempts"
- Next in thread: BP Margolin: "Re: When comparing a field name with a column name of more than one word"
- Reply: BP Margolin: "Re: When comparing a field name with a column name of more than one word"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]