set sqlprompt to something useful

I'd like to set my sqlprompt in my login to something like

user dbSID>

but can't get the stuff into the prompt.

set sqlp = select username||'> ' from user_users; doesn't work and neither does setting a variable.

how do I get it to eval the stuff on the right before making the assignment?

thanks,
Cary

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 09 1999 - 14:36:02 CST