Hi i am using sql 2000 . i am searching all the records into the database,
for this i have used the 'Like %' in my query ..For Example
Select * from table1
WHERE Col1 Like '%'

I keep getting this error whenever I try to describe any of the
entities in my database using their given name:
Missing name type for name entity in phrasing.
I'd like to know the exact cause of this problem, though I think my

I received a csv file which has a date column. The date format in this
column is 6-Mar (6 stands for 2006 which means Mar 2006). I will import this
data to an sql table and i want to date to look like 3/1/2006. Is it
possible. Kindly advise.

I have two tables each with concatenated key - ContractNo, SerialNo, JobNo, PNo
I would like to find out missing records in the other table, something like
select  ContractNo, SerialNo, JobNo, PNo from table a
where not exists ( ContractNo, SerialNo, JobNo, PNo from table b)

Is there anyway to query out the special character ' i.e. foot.  We have a
table in a database that has data in it containing the foot and inch
characters.  We need to remove these and I can find using 'like' with the "
inch but can't with the ' foot.

I'm using sql 2000 and Access 2003. I trying to query on a date field. I need
to display any records from the current date and greater then. What criteria
do I use to display these records?
Thanks,