Here is an example of my results with my T-Sql:

SELECT CHARINDEX('4', Amount, 1) AS Length, Amount, EnrollmentYear, CHARINDEX('4', SSN, 1) AS Expr1, CAST(Amount AS varchar(50))

AS CastExample

FROM dbo.[Benefits.Benefits]

525.342009025.34

026.922009126.92

00200910

00200900

00200900

00.9200930.9

39.43200969.43

026.922009026.92

00.9200960.9

00200910

0180.3720096180.37

00.9200900.9

09.5799999237060547200989.58

022.522009622.52

00200900

0126.0599975585937520090126.06

00200900

010.9099998474121092009810.91

00200960

026.9200000762939452009826.92

02.809999942779541200982.81

00200900

05.61200905.61

07.73200917.73

026.922009026.92

02.7000000476837158200982.7

00200930

33.42200933.42

0252009325

00200930

011.7700004577636722009811.77

0126.0620093126.06

016.892009316.89

02.81200902.81

00200900

019.52009119.5

017.7700004577636722009017.77

0802009680

06.57200906.57

00200910

0852009085

39.4300003051757812200909.43

00200900

00200930

00200980

016.892009016.89

00.9200980.9

013.582009313.58

00200910

022.5200004577636722009022.52

00200980

00200980

224.552009024.55

00200960

00200930

1402009040

00200900

00200980

NULLNULLNULLNULLNULL

Sorry for the mess.

I tried to do a cast to varchar and it rounded the result