Goal: Take a 3 character alphanumeric and change the first character to ‘1’.
The following explanation is for an UltraQuest user.
In the columns dialog, click on the ‘Add (x*y)+2’ button to add an expression.
In the ‘Expression’ field enter: ‘1’ cat substr(column name, 2,2)
Instead of typing the column name, select the appropriate column name from the ‘Database Table column’ list box and click the ‘Insert’ button.
In the Column format field enter A3.
Enter an appropriate column heading in the ‘Heading’ field.
If you have any questions please don't hesitate to contact Support Center.