Defining a Text field based on its condition

Giganews Newsgroups
Subject: Defining a Text field based on its condition
Posted by:  C.Hirsch
Date: Tue, 30 May 2006

I have a db with customer names that have not been populated the same way in
each field.  I would like to be able to look @ the name in the field and in
another field in another column give it an identifier or group id.  The logic
statement needs to check the condition and determine what to populate in the
"new column" based on what is in the "existing column"

Example

Existing Column      New Column
ABC Co                  Team #1
XYZ Inc                  Team #2
abc co                    Team #1
XYZ                        Team #2

thanks,
C.Hirsch

Replies