if statement on cast function possible?

[omar999]

I have the following cast function which multiplys a column value by 1.1 to display on a webpage.

SELECT *, Twin_Band_1 = Cast( Twin_Band_1 * 1.1 as int) FROM MYTABLENAME WHERE ID = '1'"

if twin_band_1 = NULL in sql db isit possible to display '-' instead or a   or any other text for that matter?

thanks in advance
Omar.

[Delerna]

No both of those are strings and you are casting the field as int

How about something like this

Cast( isnull(Twin_Band_1,-1) * 1.1 as int)


and then on the webpage check for -1.1 and convert it to " " or "-"

[omar999]

thanks delerna - I've tried your suggestion but no joy as the webpage displays "False"

Twin_Band_1 = Cast( isnull(Twin_Band_1,-1) * 1.1 as int)

Response.Write "<td>" & objRS("Twin_Band_1") = replace(objRS("Twin_Band_1"), "-1", "testreplace") & "</td>"

not sure where im going wrong?

[omar999]

iv figured this out - wohoo. I've used my original sql cast function with corrected asp code as follows;

]SELECT *, Twin_Band_1 = Cast( Twin_Band_1 * 1.1 as int) FROM MYTABLENAME WHERE ID = '1'"

Response.Write "<td>" & replace(objRS(Trim("Twin_Band_1")), "-1", "-") & "</td>"

thanks anyway
omar.

[Delerna]

always good to see someone figure out their own problem.
Thanks for the update.