I have a MS SQL table that has about 2M records in it. I had to add a field that is actually a combination of the month and year to it for some reports I am running. Foolishly I named columns month, year, day in this table so I think it is a problem with trying to write a query that takes the month value and combines it with the year value to give me month year.
I tried writing something like Update tableA Set monthYear= [TableA].[month] + [TableA].[year] where mothYear is null All it does it set it to the year value. -- Dan Stein MSN CPNP FileMaker 7 Certified Developer FileMaker 9 Certified Developer Digital Software Solutions 303 W. Chestnut St Souderton PA 18964 Land: 215-799-0192 Cell: 610-256-2843 Fax 215-799-0192 ( Call 1st) FMP, WiTango,MSSQL, MySQL,PHP [email protected] www.dss-db.com "It's very hard to grow, because it's difficult to let go of models of ourselves in which we've invested so heavily." ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body.
