SQL Server ASCII Function Equivalent

[kpuser]

In SQL Server, this query...

...yields these results:

How do I duplicate this in Alteryx?

[CharlieS · Accepted solution]

The CharToInt( function will convert the character to the Unicode integer value 

CharToInt(Substring("3CJUNCC3",2,1))

The expression above gives us 74. The other difference you'll notice is the substring position will change to "2" in Alteryx. 

Alternative code sets can be referenced using the ConvertToCodePage( and ConvertFromCodePage( functions and the libraries mentioned in the documentation linked below:

https://help.alteryx.com/current/CodePages.htm