Mysterious 'x' when retrieving records

2004-03-11 Thread Jacque Scott
I have a very simple query SELECT ProblemReports.* FROM ProbelmReports; If there is no data in the column 'Description' it returns 'x'. There is no default value being used and there is no data in the field. Why would it return 'x'? The field type is 'TEXT'. I have another 'TEXT' field in

RE: Mysterious 'x' when retrieving records

2004-03-11 Thread Victor Pendleton
Can you post some sample data and ddl? -Original Message- From: Jacque Scott To: [EMAIL PROTECTED] Sent: 3/11/04 3:12 PM Subject: Mysterious 'x' when retrieving records I have a very simple query SELECT ProblemReports.* FROM ProbelmReports; If there is no data in the column

RE: Mysterious 'x' when retrieving records

2004-03-11 Thread Jacque Scott
some sample data and ddl? -Original Message- From: Jacque Scott To: [EMAIL PROTECTED] Sent: 3/11/04 3:12 PM Subject: Mysterious 'x' when retrieving records I have a very simple query SELECT ProblemReports.* FROM ProbelmReports; If there is no data in the column 'Description