Convert string to float with exponencial numbers

Question

I need to convert a string to float I need u-sql code.

the script could be an exponencial like 10^2

I tried Float.Convert but not works.

I expect

convert(10^2) = 100

Answer 1

Assuming this is your own format is You will need to write a C# function to do that.

You can write code behind

https://www.purplefrogsystems.com/paul/2017/04/calling-u-sql-stored-procedures-with-c-code-behind/

or functions

https://sqlplayer.net/2017/10/functions-in-the-usql-the-hidden-gem-in-the-summer-2017-update/