SQL Query to combine to text fields

Point-Of-Sale Software - - MS Point Of Sale software discussed here 

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date SQL Query to combine to text fields Terrible TomúÚ&€c…!!롼¬~êçŠÛ« 11-02-2005  Re: SQL Query to combine to text fields Evan Culver 11-03-2005  Re: SQL Query to combine to text fields Terrible TomúÚ&€c…!!롼¬~êçŠÛ« 11-03-2005  Re: SQL Query to combine to text fields Matt 11-03-2005  Re: SQL Query to combine to text fields Evan Culver 11-03-2005  Re: SQL Query to combine to text fields Terrible TomúÚ&€c…!!롼¬~êçŠÛ« 11-04-2005
Posted by Terrible TomúÚ&€c…!!롼¬~êçŠÛ« on November 2, 2005, 11:07 am Please log in for more thread options I want to run a query that will append the Item.SubDescription1 field to the Item.Description. Something like this: UPDATE Item SET Description = Description + ", " + SubDescription1 Is this possible? What would be the proper syntax? Thank you, Tom -- The worst words in business: "We''ve always done it that way" -- Stop Fishing for eMail. Posted by Evan Culver on November 3, 2005, 1:21 pm Please log in for more thread options Tom, UPDATE i SET Description = SUBSTRING(i.Description + ', ' + i.SubDescription1, 0, 31) FROM Item i - Evan Culver New West Technologies Terrible Tom wrote: > I want to run a query that will append the Item.SubDescription1 field to the > Item.Description. > > Something like this: > UPDATE Item SET Description = Description + ", " + SubDescription1 > > Is this possible? What would be the proper syntax? > > Thank you, > Tom > Posted by Terrible TomúÚ&€c…!!롼¬~êçŠÛ« on November 3, 2005, 1:29 pm Please log in for more thread options Thank you, Mr. Culver. I presume that "i" represents a specific item in the example you provided. If I use "Item" where you have "i" will this query update all items? I'm hoping to apply this to every item in my database Thanks again, Tom "Evan Culver" wrote: > Tom, > > UPDATE i > SET Description = SUBSTRING(i.Description + ', ' + i.SubDescription1, 0, 31) > FROM Item i > > - > Evan Culver > New West Technologies > > > Terrible Tom wrote: > > I want to run a query that will append the Item.SubDescription1 field to the > > Item.Description. > > > > Something like this: > > UPDATE Item SET Description = Description + ", " + SubDescription1 > > > > Is this possible? What would be the proper syntax? > > > > Thank you, > > Tom > > > Posted by Matt on November 3, 2005, 1:37 pm Please log in for more thread options Tom, In the query it says "From Item i," which means that wherever there's an "i" it means item. So the "i.*" means "Item.*" Just a shortcut, that's all. Hope this helps, Matt > Thank you, Mr. Culver. > > I presume that "i" represents a specific item in the example you provided. > If I use "Item" where you have "i" will this query update all items? > > I'm hoping to apply this to every item in my database > > Thanks again, > Tom > > "Evan Culver" wrote: > > > Tom, > > > > UPDATE i > > SET Description = SUBSTRING(i.Description + ', ' + i.SubDescription1, 0, 31) > > FROM Item i > > > > - > > Evan Culver > > New West Technologies > > > > > > Terrible Tom wrote: > > > I want to run a query that will append the Item.SubDescription1 field to the > > > Item.Description. > > > > > > Something like this: > > > UPDATE Item SET Description = Description + ", " + SubDescription1 > > > > > > Is this possible? What would be the proper syntax? > > > > > > Thank you, > > > Tom > > > > > Posted by Evan Culver on November 3, 2005, 1:50 pm Please log in for more thread options Tom, That query will update every item in your database -- 'i' is just used as an alias for the 'Item' table. - Evan Culver New West Technologies Terrible Tom wrote: > Thank you, Mr. Culver. > > I presume that "i" represents a specific item in the example you provided. > If I use "Item" where you have "i" will this query update all items? > > I'm hoping to apply this to every item in my database > > Thanks again, > Tom > > "Evan Culver" wrote: > > >>Tom, >> >>UPDATE i >>SET Description = SUBSTRING(i.Description + ', ' + i.SubDescription1, 0, 31) >>FROM Item i >> >>- >>Evan Culver >>New West Technologies >> >> >>Terrible Tom wrote: >> >>>I want to run a query that will append the Item.SubDescription1 field to the >>>Item.Description. >>> >>>Something like this: >>>UPDATE Item SET Description = Description + ", " + SubDescription1 >>> >>>Is this possible? What would be the proper syntax? >>> >>>Thank you, >>>Tom >>> >> Similar Threads Posted Receipt FOOTER or HEADER Bolder Text or Larger Text February 17, 2006, 9:46 am Way to combine same scanned items in POS and Manager POs? February 3, 2007, 6:19 pm combine multiple work orders February 9, 2007, 9:56 pm Combine Physical Inventory Batches August 9, 2007, 4:49 pm Text size August 31, 2007, 1:06 pm Chinese text August 21, 2008, 8:55 am Import PO from a text file? June 8, 2005, 9:12 am Importing HHT Text files November 4, 2005, 2:37 pm XML Receipt Text Comparisons October 5, 2006, 3:44 am Changing text in X and Z reports November 9, 2006, 3:20 pm