I am trying to run a select statement with a field in the where clause that I want to check the Month value of, but it is in a decimal field. The format that it currently is in is (YYYYMMDD). Any ideas on how to change the format of the field in the where clause? I need to be able to do it as follows:
Thanks for the quick reply. I will give that a try. I am new to the Informix world (as is obvious by some of my posts). I have been spoiled by some of the functions in SQL server, and I have also inherited a less than desireable data model. Guess we have to play with the hand that is dealt us.