Formula Field Int to String

[pmcfarlain]

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?

[TellMeWhy]

You can convert it to TEXT 

'CC'+CONVERT(VARCHAR, (SELECT MAX(Clean_Job) FROM tbl_ggl_job WHERE Job_Letter = 'CC') + 1))

Double check the parenthesis if it's the correct amount

[PotatoMato]

Hi @pmcfarlain,

 

Just to add, you may also use this one: 

'CC' + CAST(((SELECT MAX(Clean_Job) FROM tbl_ggl_job WHERE Job_Letter = 'CC') + 1) AS VARCHAR)

 

-Potato

[Flowers4Algernon]

Hello! Just wanted to share this link for more information regarding functions that you may use in your formula: https://howto.caspio.com/function-reference/