By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,609 Members | 2,246 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,609 IT Pros & Developers. It's quick & easy.

as400 and sql via ODBC

P: n/a
Hello,
I've a big problem, i need to adapt this sql string:
SELECT ...
FROM T4
WHERE (((IsNumeric(Trim(Mid([T4.A],5,2))))=True) AND ((T4.B)=1));
for pass-trought query access connect via ODBC to AS400
I looking for several solutiones for the substring functions that is equal
to MID function
WHERE (SUBSTRING(CHAR(T4.A),5,2))
but IsNumeric functio exist?, Please help me!

sorry for the bad english!
Tnx
Giuseppe

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.