I am working on an to solve a problem that I have a textbox that accepts any type of data but I want to cast the data to decimal(12,9)
or any data type can accept this number as an example 42.56926437219384
here is the problem the user can enter any kind of data like characters or integer
1st case I want to handle if the data entered as integer:
DECLARE @num DECIMAL(12,9) = 444444444444444
SELECT CONVERT(DECIMAL(12,9),@num)
I think if it is characters will handle it in the solution and assign validation for the textbox.
how can I handle the integer part?