Problem with select

[Joseph Morgan]

On Oct 28, 2007, at 12:32 PM, Joseph Morgan wrote:

> table customers with 2 examples (there are approx 200 records total):
>
> Long:	Text:			Text:			Text:			Text:			Text:			Text:
> _rowID	accountName	contactName	phone			fax				address			city
> 13		CPS			Nancy			000-000-0000	000-000-0000	1121 Main		Boerne
> 129		The Rustic Mile	Paul			000-000-0000	000-000-0000	13807 Hwy 281	 
> San Antonio
>
> select * from customers where accountName = 'CPS'
> returns 0 records
>
> select * from customers where accountName = 'The Rustic Mile'
> returns 0 records
>
> I tried to reindex the database as Ruslan suggested and nothing  
> changed.


Now i deleted all records except for the 'CPS' account ( to eliminate  
the chance that other records contain illegal characters).

select * from customers where accountName = 'CPS'

This still yields no records.

Joseph