SQLCategoria = "Select * from Biblioteca_Categoria where Len(Codigo) = 6 order by Codigo asc" ??

V

Vilmar

Hi,
Why the instruction runs ok on sql server 2000 but in access 2000 brings me
the maximum size of field in the table:

SQLCategoria = "Select * from Biblioteca_Categoria where Len(Codigo) = 6
order by Codigo asc"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MySQL - How to use SELECT UNION with different ORDER BY statements? 0
Sort by number of characters 1
Positioning student result by ranking grade 1
Inconsistent results from Len function? 5
Select top 40 * from and Order By 4
Python client/server that reads HTML body from server 1
How can i fix Mysql images not found error? 0
order by where.... 5

Members online

Total: 26 (members: 3, guests: 23)
Robots: 80

Forum statistics

Threads
473,780
Messages
2,569,611
Members
45,276
Latest member
Sawatmakal

Latest Threads

Top