Viewing 2 posts - 1 through 2 (of 2 total)
SELECT * FROM Company WHERE EFF0YR = '112' AND EFF0MO = '09' AND EFF0DA BETWEEN '01' AND '09'
use str command to give the string values in sql query instead of...
March 14, 2012 at 2:33 am
#1459024
you me need to use the openquery
select * from OPENQUERY(<DB2 server>, <select statement within single quotes>)
March 13, 2012 at 3:51 am
#1458364