SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Hybrid View

  1. #1
    SitePoint Enthusiast
    Join Date
    Jan 2004
    Location
    London
    Posts
    87
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Special Charcters

    Hi,

    I need to use a special character within an SQL statement that has no affect within that statment.

    Does the @ sign have any function within SQL?


    I basically looking for a statement section similar to this

    AND field LIKE '%@word@%'

    Where I would find all the rows where field contained @word@.

    Does this make sense and is it ok to use?

    Thanks,


    Richard

  2. #2
    Tranceoholic lilleman's Avatar
    Join Date
    Feb 2004
    Location
    Írebro, Sweden
    Posts
    2,716
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    Yes, that's OK. You can use any characters you want inside a string, and when using LIKE, only the percentage character (%) have a special function (if I'm wrong, please correct me ).

    Yours, Erik.
    ERIK RIKLUND :: Yes, I've been gone quite a while.


Bookmarks

Posting Permissions

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