(RADIATOR) concatenation within select statement

[calvin kwok]

hi,

In normal SQL statement, you can concatenate variable
with  "&" sign, can you do this in AuthSelect
statement?
eg.
if you are going to separate the realm and username in
the db table and you strip the realm from the username
and authenticate the name and realm part separately
using the following statement,
AuthSelect select USERNAME & @%R',PASSWORD,Realm from
SUBSCRIBERS where '%n'=USERNAME & '@%R' and Realm='%R'

	
if you cant do this, how can you store the realm
variable after UsernameRewrite so that it can be
retrieve later to check against the database?

regards
calvin






__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Mother's Day is May 12th!
http://shopping.yahoo.com
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.