[AccessD] search 4 characters

Paul Hartland (ISHARP) paul.hartland at isharp.co.uk
Wed May 11 03:51:34 CDT 2005


Pedro,

If you only want to return strings that are four characters in length use
the following:

	Len(Trim(YourFieldName))=4

Paul Hartland 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of pedro at plex.nl
Sent: 11 May 2005 10:47
To: accessd at databaseadvisors.com
Subject: [AccessD] search 4 characters

Hello Group,

what can i use in a query to search for strings that have only 4 characters.

Like "&&&&" 

or

Like "____" 

isn't working

Pedro Janssen
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list