how do I retrieve length of entry in access database

From: Pascal Schmidt-Volkmar (nospam_at_schmidt-volkmar.com)
Date: 03/27/04 

Date: Sat, 27 Mar 2004 11:36:40 +0100

Hi there,

I have an access string column that allows entries of 255 length. Now I
would like to find out via SQL how long the entries really are.

I tried "SELECT art_pzn FROM Artikel WHERE LENGTH(art_pzn)>7" but failed.

How could you do that??

Thanks,

Pascal