sql string length

  • Thread starter Thread starter PF
  • Start date Start date
P

PF

Hi,

What is lthe maximum length of a sql string in access 2000?
Is there a limit on the length of the where clause?

What do you do when yo have a select statem,ent involving 50 fields?
Is there a way to put the field name in a table and select from that table
(in a network)?

Pierre
 
Hi,


for Access 2003 (probably the same for 2000):


Number of ANDs in a WHERE or HAVING clause: 99
Number of characters in an SQL statement: approximately 64,000




If you have 50 fields in the select clause, you type them ( the graphical
designer allow you do drag a list of field, rather than using *: double
click the table to select all the fields, drag them in the grid).




Hoping it may help,
Vanderghast, Access MVP
 
Back
Top