Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Concat

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Concat

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • April 24, 2003 at 7:40 pm #7869
      dfi
      Member

      Can someone tell me how one goes about putting fields together. In MS Access, I use all kinds of Trim Statements with Lefts and Rights for a variety of purposes. Here I cannot figure out the proper syntax. The following is an example from Access:

      UPDATE Voter SET Voter.HH = Trim(Soundex(Left([lname],5)) & Right([hn],4) & Left([sn],5) & Left([zip],5));

      DL

    • April 25, 2003 at 5:32 pm #14147
      Ritesh
      Member

      Hell

      There are similar functions like Trim, Right, Left etc. in MySQL. You can get more information on these functions from the MySQL Docs.

      HTH

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.