Search the Community
Showing results for tags 'integer'.
I have a formula field which calculates a number value perfectly but I'd like to add a letter to the front of the number so I assume that means I need to cast my result to a string. Here is my formula right now: SELECT MAX(Clean_Job) FROM tbl_ggl_job WHERE Job_Letter = 'CC') + 1 Which gets the max job number that is currently in use and adds 1 to that. So if the max job is CC100 this would return 101. I'd like to concatenate this with the Job Letter CC so that the result would look like CC101. How can I do this?
I have an integer data type and I would like to display my records that start with 0 as it is. For example, I want my '01' to be displayed as '01', not as 1. Is there a way to display a '0' before a number using number or integer data type?