>I am creating a query that will be used for a cross-tab report. As you can see, in the first field I am putting several items into one string, later in VFP for my report I use the strextract to pull out the items I need to print. I need to include the unit cost of the inventory item in that that same string, but it is not a string type. The Total cost is stored in the coInv.CostBeforeCF field (Decimal 9,2). The CF field is an int. The unit cost is calculated by CostBeforeCf/CF. This seemed like a good place for the SQL UDF. But I got myself all confused reading the BOL.
>
< snip >
Can you use CAST or CONVERT to convert coInv.CostBeforeCF to string?
--sb--