| Appending text to fields [message #173504] |
Mon, 22 May 2006 14:42  |
BoogiePeople
Messages: 1
Registered: May 2006
Location: St. Louis, Missouri
|
Junior Member |
|
|
Howdy.
I need to know how to append text into field boxes. For example, the field is a client's name. I want to append "Client's name is" to the beginning.
Thanks for any help.
Ron
(using Oracle 10g)
|
|
|
|
| Re: Appending text to fields [message #173535 is a reply to message #173504] |
Tue, 23 May 2006 00:41  |
 |
Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
One way would be, during writing a query, something like this:
SELECT 'Client''s name is ' || c.client_name
FROM clients c
Another way would be creating a formula column which would have something like:
RETURN ('Client''s name is ' || :client_name);
Finally, the simplest way is setting the default field label to "Client's name is".
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
