Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2010
    Location
    ISHHHH
    Posts
    130

    Unanswered: how to get special symbols in sql

    Hi,
    i want to get special symbols in the output like () r { } r [] let me elaborate i had a table in which it has some data i want to divide them by brackets () i tried it using as but it is taking in condition can any one help me thanks in advance
    WiTh Tnks & ReGaRdS
    mAtHuKuMaLi

  2. #2
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    You need something like this?
    Code:
    SELECT Column1 + ' (' + Column2 + ') '
    FROM MyTable
    WHERE somecondition = 'True'
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  3. #3
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    select char(21),char(13), etc

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •