R RUDOLFSUN Registered User. Local time Today, 01:47 Joined Dec 14, 2006 Messages 23 Dec 14, 2006 #1 hello if any one can help me create a query that pick out lower case characters from the beggining of words, and the beggining of each word in a sentance , my christmas would be made! Thanks in advance
hello if any one can help me create a query that pick out lower case characters from the beggining of words, and the beggining of each word in a sentance , my christmas would be made! Thanks in advance
SRAB Is it Friday? Local time Today, 04:47 Joined Jul 6, 2006 Messages 31 Dec 15, 2006 #2 What do you mean by "pick them out"? Do you want to change the case? Look up StrConv function for help converting text; also try the Asc function.
What do you mean by "pick them out"? Do you want to change the case? Look up StrConv function for help converting text; also try the Asc function.
Fifty2One Legend in my own mind Local time Today, 01:47 Joined Oct 31, 2006 Messages 1,410 Dec 15, 2006 #3 in your query put Expr1: ASC(left(fieldName,1)) in the criteria put >= 97 AND <= 122
