Problem with select

[Joseph Morgan]

On Oct 28, 2007, at 12:20 PM, Thorsten Hohage wrote:

> a) did you rename a column or content and what was the original  
> content?
>
> b) instead of using samples , can you give REAL names and REAL  
> content samples, here?


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.

Joseph