half dozen lines of SQL or access query for Volusion

The following is the standard Volusion google export script with 3 comments in it. The first 2 I don't know how to conditionally replace what I want. The third needs the field to be referenced correctly. TIA! SELECT '[login to view URL] =' + [login to view URL] + '&click=35' AS link , [login to view URL] AS title , [login to view URL] AS [stripHTML-description] , 'Config_FullStoreURLConfig_ProductPhotosFolder/' + [login to view URL] + '[login to view URL]' AS image_link -- if [CategoryTree-product_type] ="MOTORCYCLE" then image_link = PhotoURL_Small , [login to view URL] AS [CategoryTree-product_type] -- if [CategoryTree-product_type] ="MOTORCYCLE" then [login to view URL] = CustomField5 -- METATAG_Keywords as label , IsNull([login to view URL],[login to view URL]) AS price , [login to view URL] AS id FROM Products p INNER JOIN Products_Descriptions pd ON [login to view URL] = [login to view URL] INNER JOIN Products_Extended pe ON [login to view URL] = [login to view URL] WHERE ([login to view URL] is NULL OR [login to view URL] = '') AND ([login to view URL] is NULL OR [login to view URL] 'Y') AND ([login to view URL] > 0) ORDER BY [login to view URL] Edit/Delete Message