Problems Extracting the last value form a column

[neromerob]

Hello to everyone.

I´m writing because I have a problem extracting the last value of a filed.

This is the error that I got and I don´t know how to fix it.

As the graphic shows the field is "integer".  and the result should look like this 

thank you 

[Eduardo_Ortiz]

Could you please provide what error is bigquery returning you sou? Since the image is very small, but I can see that you are trying to make use of the string functions you can read more on the documentation I shared with you.

[darsh_shukla]

Hi, 

Below is the solution for the same. You can use DIV Function or

SUBSTRING Function, if using string functions you have to CAST the value to STRING type. Here I am using SAFE_CAST instead of CAST function to handle NULLs.