| Steen Persson (DK) 2006-03-09, 11:23 am |
| Bob wrote:
> I have a simple table named Postes the sql statement that my program
> executes is select * from postes where IdPosteTelephonie = '12345678900'
>
> This has worked flawlesly for ages. Now suddenly the statement returns an
> empty redordset although when I go through the table I can find the record
> whose field IdPosteTelephonie has value 12345678900. Its in the table.
>
> I ran a dbcc on the database and got no errors returned.Tried it again after
> the dbcc , still same results. Everything else on the computer seems to work
> OK.
>
> Weirdest thing I've seen so far. I desperateley need good help. This is on
> a vital production system.
>
> Thanks for any help you may provide.
>
> Bob
>
>
>
>
Depending on the columns type, could it then be that you have a Space or
another "invisible" character either before or after the string? You
could try to use LIKE %.....% instead of = to see if that makes any
difference.
Regards
Steen
|