Thanks for your answer Amarnath,
The thing is that in my Database, this champs is not in DateTime format but in Text format, and the '99999999' means forever.
I fix this probleme with a CASE expression, instead of a REPLACE.
MuadDibII
Last Activity: May 3 '11, 03:53 PM
Joined: May 6 '10
Location:
-
Error when trying to replace one sub-query
Hi all,
After several jours of testing and research, i decided to write on this forum that help me a lot of times.
I'm doing a realy big query in an Access aplication that i'm working now (it's an Access SQL Direct query to an AS400 data base):
At my WHERE clause, I've some sub-querys:
...Code:WHERE (ntlrp in(select noclie from pack10pdta.agposp0s where codde1='EUR' and etacpt<>3 and nacmpt in ('205','210','211','212','213','214','215','216','260','261','262','263','264','265','266','267','268'))
No activity results to display
Leave a comment: