Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. pmcd20

    Joining a column with the column value + String

    Thank you mirtheil the rtrim did the trick. Thank you The previous way that I was doing it did not give an error nor did it add the 'n'
  2. pmcd20

    Joining a column with the column value + String

    Example When i have a column comment3' from the table 'TEST' If i run, the string value n will get added to the start one record resides in table comment3 current value = 'pink' UPDATE Test SET comment3 = CONCAT('n',comment3)# This returns = 'npink' However i want it the other way. For...

Part and Inventory Search

Back
Top