Larry,
Quite clever. I did not know you can use the piping symbol in this syntax.
Where can I find more information on the use of the piping symbol in R:Base?
Thanks.
Stan Loo
---------------------------
Try
SELECT +
IFGT(SLOC('|Mrs|Ms|Miss|', '|'+Title+'|'), 0,
'Female', Male') +
FROM TableView
which is almost the function you requested. It should
work as long as Title is guaranteed to be free of the
Pipe character.
A better solution is to create a table of Titles with
a specification of the gender it applies to, and join
that table into your selection. It's better because
you can add new Titles to the table without ever
having to look at or modify your code.
--
Larry
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
