http://kb.mayfieldglobal.com en-us http://kb.mayfieldglobal.com ActiveKB NX vadim.tkachuk@gmail.com Fri, 10 Sep 2010 13:50:28 PDT 20 http://kb.mayfieldglobal.com/questions/54/ http://kb.mayfieldglobal.com/questions/54/ Use + to concatenate two columns. For example: SELECT DeviceMgf.MfgName + ' ' + DeviceModel.ModelName AS Device, DeviceModel.ModelIDFROM DeviceMfg INNER JOIN DeviceModel ON DeviceMfg.MfgID = De ... Vadim Tkachuk Fri, 12 Jan 2007 23:42:47 PST http://kb.mayfieldglobal.com/questions/71/ http://kb.mayfieldglobal.com/questions/71/ Operator Definition = Equal to. <> Not equal to. != Not equal to. This operator is the same as the <> operator. > Greater than. &g ... Vadim Tkachuk Thu, 15 Mar 2007 20:44:27 PDT http://kb.mayfieldglobal.com/questions/72/ http://kb.mayfieldglobal.com/questions/72/ Operator Description AND Evaluates as true if both of the criteria are true. OR Evaluates as true if either of the criteria is true. NOT Used with the above ope ... Vadim Tkachuk Thu, 15 Mar 2007 20:43:24 PDT