Problem with select

[Ruslan Zasukhin]

On 28/10/07 5:57 PM, "Joseph Morgan" <joseph at checkos.com> wrote:

Hi Joseph, 

> I am trying the following select and it returns nothing.
> 
> select * from customers where accountName = 'testAccountName'
> 
> I know there is a row where accountname = test but valentina
> returns 0 rows.

I do not catch.

Table have row as 

     accountName   
    -------------------
    | test             |


And you try find it using

    where accountName = 'testAccountName'

??

This is not correct of course.

    where accountName = 'test'

Will find it.



> The ContactName field works:
> select * from customers where contactName = 'testContact'
> 
> I can't tell why one field works and the other doesn't.
> 
> I know that some of the accountnames where imported from mysql and
> some look like this:
> U.S. Tae Academy
> Fly-Boy Electronics
> 
> Does '.' or '-' cause problems?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]