How does one concatenate strings with fields using calculated fields
1 April, 2011
How does one concatenate strings with fields using calculated fields?
Which database are you using?
You should be able to use the + function, though this does depend on the database.
If your database doesn?t support this, you might have to use a freehand sql calculated field .
Please let me know how you go.
Regards,
David
Hi David,
I'm using Oracle and have tried using the '+' but it doesn't work.
I'm using Oracle and have tried using the '+' but it doesn't work.
Hi,
You should be able to create a freehand calculated field at the view level (see screenshot below), you can try using the CONCAT command or || (pipes).
Please let me know if you cannot get this to work.
Regards,
David
You should be able to create a freehand calculated field at the view level (see screenshot below), you can try using the CONCAT command or || (pipes).
Please let me know if you cannot get this to work.
Regards,
David