Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Translate "where" param to MS Access

Status
Not open for further replies.
thedaver

thedaver

IS-IT--Management
Jul 12, 2001
2,741
US
I'm sorry to ask this but.......
I have an Oracle select statement that uses the "where" parameter

where Translate(upper(login),'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789','CCCCCCCCCCCCCCCCCCCCCCCCCCNNNNNNNNNN') like 'CCNNCCN%'

This is intended to match the upper-case value of the 'login' to a pattern matching 'CCNNCCN%' where C=chars and N=numbers.

Does Access' SQL make this possible? How do I translate this statement to Access?

Surfinbox.com Business Internet Services - National Dialup, DSL, T-1 and more.
 
Status
Not open for further replies.

Similar threads

deo1
  • Locked
  • Question
Please help with forms6i ole2 ms word
Replies
0
Views
127
deo1
deo1
faizsaadq
  • Locked
  • Question
How to call crystal reports XI from Oracle Forms 10G
Replies
1
Views
154
oradba101
oradba101
JenniferCheng
  • Locked
  • Question
"No rows selected" message
Replies
1
Views
58
thebull1
thebull1
mrfritz44
  • Locked
  • Question
"SELECT TOP" in Oracle SQL
Replies
4
Views
85
nagornyi
nagornyi
howzatUK
  • Locked
  • Question
Translate from SQL Server to Oracle
Replies
0
Views
34
howzatUK
howzatUK

Part and Inventory Search

Sponsor

Back
Top