Substring special characters

Discussion in 'ASP .Net' started by David C, May 5, 2008.

  1. David C

    David C Guest

    How do I search for CrLf in a text column? I was thinking of "....WHERE
    SUBSTRING(Subfile,1,1) LIKE '%vbCrLf%' but I know that is VB syntax.
    Thanks.

    David
     
    David C, May 5, 2008
    #1
    1. Advertising

  2. On May 5, 11:35 am, "David C" <> wrote:
    > How do I search for CrLf in a text column? I was thinking of "....WHERE
    > SUBSTRING(Subfile,1,1) LIKE '%vbCrLf%' but I know that is VB syntax.
    > Thanks.
    >
    > David


    I would find the SQL group and ask them how you would substring for a
    line break in a text column.
     
    cfps.Christian, May 5, 2008
    #2
    1. Advertising

  3. David C

    bruce barker Guest

    just include it in the search string. in sql no special char is needed as lf
    is not a line terminator.

    select *
    from foo
    where myColumn like '%
    %'


    -- bruce (sqlwork.com)


    "David C" wrote:

    > How do I search for CrLf in a text column? I was thinking of "....WHERE
    > SUBSTRING(Subfile,1,1) LIKE '%vbCrLf%' but I know that is VB syntax.
    > Thanks.
    >
    > David
    >
    >
    >
     
    bruce barker, May 5, 2008
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Stefan Mueller
    Replies:
    3
    Views:
    33,043
    Stefan Mueller
    Jul 23, 2006
  2. Replies:
    2
    Views:
    1,095
    Ingo Menger
    May 31, 2007
  3. rvino
    Replies:
    0
    Views:
    4,660
    rvino
    Aug 14, 2007
  4. Replies:
    3
    Views:
    204
    Sherm Pendley
    Aug 3, 2005
  5. majna
    Replies:
    4
    Views:
    676
    Thomas 'PointedEars' Lahn
    Sep 19, 2007
Loading...

Share This Page