Hi,
While trying your case I've took recently posted by Jack DDL:
CREATE TABLE [MonthLookup] (
[month_id] INT IDENTITY(1,1) NOT NULL,
[month_value] VARCHAR(40) NOT NULL,
CONSTRAINT [PK_MonthLookup] PRIMARY KEY ([month_id])
)
and created my JDBC row set this way (here '+' is used as strings concatenation function under MS SQL, for Oracle/MySQL you would use CONCAT() function):
showDeleted="true" sqlQuery="select month_value+'123' as mv from MonthLookup">
and then specified my view column as this:
id="viewColumnHeader3" value="Month value" sortable="true">
That works for me and shows properly values taken from that original month_value field, concatenated with '123' string, via mv alias.
If you have some DDL/SQL query you are trying to use - could you provide it?