>>1. Change lcNumber to be a parameter - to avoid SQL injection attacks.
>>
>>2. Try to list all the fields explicitly.
>>
>>3. The code dr.Read() should be changed to
>>
>>while dr.Read()
>> lcData = dr("Comment").ToString()
>
>Thanks for the suggestion. But I discovered the problem actual never existed. The text field actual did have numbers in them and the dataset was being read correctly. I guess should have look at the data before assuming i was getting the wrong data.
Good, but still better to adjust your coding.
If it's not broken, fix it until it is.
My Blog