>Hello UT.
>
>

>DECLARE @idoc int
>DECLARE @doc varchar(8000)
>DECLARE @Amount varchar(20)
>
>SELECT @Amount = '$0.00';
>
>
>SELECT @doc=RatingWorksheetXML FROM PolicyRating WHERE PolID = '925379 '
>
>--Create an internal representation of the XML document.
>EXEC sp_xml_preparedocument @idoc OUTPUT, @doc
>
>SELECT  @Amount = Amount FROM   OPENXML (@idoc, '/RateWorksheet/Item[Desc=''Windstorm Protective Devices Credit'']',2)
>			WITH (Amount varchar(30))
>
>
>SELECT @Amount  as Amount
>

>
>The value return of @Amount is "$17"
>I need to convert @Amount to int type to do some math substruction.
>
>
>Any help is appreciated.
>
>Thanks

DECLARE @idoc int
DECLARE @doc varchar(8000)
DECLARE @Amount varchar(20)

SELECT @Amount = '$0.00';


SELECT @doc=RatingWorksheetXML FROM PolicyRating WHERE PolID = '925379 '

--Create an internal representation of the XML document.
EXEC sp_xml_preparedocument @idoc OUTPUT, @doc

SELECT  @Amount = Amount
       FROM   OPENXML (@idoc, '/RateWorksheet/Item[Desc=''Windstorm Protective Devices Credit'']',2)
       WITH (Amount varchar(30))

SELECT CAST(REPLACE(@Amount,'$','') as int)  as Amount

not tested

Are you sure the Amount should be int?
As I see it is a money, what will happens if you have value like 9.99?