When I used this code:
dateFrom =rtrim(ltrim(cstr(convNull(objHistoryRate("decHour lyRate"))))). The values in the database were 50 and used to give 50 in asp. Know when I try to change the code to
dateFrom=cstr(convNull(objHistoryRate("decHourlyRa te"))). The values in the database changed to Null and in txtboxes in an asp showed up no values. When I try to rewrite the code back to the original one
dateFrom=rtrim(ltrim(cstr(convNull(objHistoryRate( "decHourlyRate")))))
gives a run time error. Please explain the reason

Hi Shoakat,

That is because, you already have NULL in the table, on which you are trying to do the trimming job, which doesn't make sense.

It better that you try and explain us what you are trying to achieve so that we would help you get there, than posting the code and asking us the reason for its behaviour.

Cheers!

_________________________
- Vijay G
Strive for Perfection