Float/real estate encoding is the character Area

 

 

 

-- Class sequence Operators

 

Declare
@ T table
(
Num float
(
38 ))
-- Float/real

Escape as a character

Insert
@ T select
1230

Union all
Select
1234

Union all
Select
123.45

Union all
Select
123.456

Union all
Select
123.4567

Union all
Select
123.45678

 

Select
*,
Rtrim
(
Num)
As
[
Directly escape as a character
] From
@ T

/*

Num

Directly escape as a character

----------------------
-----------------------

1230
1230

1234
1234

123.45
123.45

123.456
123.456

123.4567
123.457 --
With shards

123.45678
123.457 --
With shards

*/

 

 

Select

[
Escape as a character
] =
Case
When
Len
(
Num) =
Charindex
(
'.'
,
Num)
Then
Stuff
(
Num,
Len
(
Num ),
1,
''
)
Else
Num end

From

(

Select

Num = left (
Num,
Len
(
Num )-
Patindex
(
'% [^ 0] %'
,
Reverse
(
Num) +
1)

From
(

Select
Rtrim
(
Cast
(
Num
Decimal
(
38,
10 )))
As
Num from
@ T

)
T

)
T2

/*

Escape as a character

--------------------

1230

1234

123.45

123.456

123.4567

123.45678

 

*/