To convert a big number's datatype from text to decimal

I am fetching a large number like '9999999.99' from the database where it is in nvarchar.
Can we convert it in decimal to compare it with other numbers? Using fn!todecimal is not working here, Is their any work around?

Thanks in Advance.

OriginalPostID-254015

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data