Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. I need a SQL statement....

I need a SQL statement....

Scheduled Pinned Locked Moved Database
databasetutorial
5 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    Mazdak
    wrote on last edited by
    #1

    I need a SQL statement which retreive all strings start with special charachter. For example all words start with 'M' in recordserts. Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here."
    Wish You Were Here-Pink Floyd-1975

    O S 2 Replies Last reply
    0
    • M Mazdak

      I need a SQL statement which retreive all strings start with special charachter. For example all words start with 'M' in recordserts. Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here."
      Wish You Were Here-Pink Floyd-1975

      O Offline
      O Offline
      Omer S
      wrote on last edited by
      #2

      SELECT X FROM Y WHERE X LIKE 'M%' Omer.

      M 1 Reply Last reply
      0
      • M Mazdak

        I need a SQL statement which retreive all strings start with special charachter. For example all words start with 'M' in recordserts. Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here."
        Wish You Were Here-Pink Floyd-1975

        S Offline
        S Offline
        sreejith
        wrote on last edited by
        #3

        Here is the sql stmt SELECT * FROM WHERE Name like 'M%' Sjt From Heaven

        M 1 Reply Last reply
        0
        • O Omer S

          SELECT X FROM Y WHERE X LIKE 'M%' Omer.

          M Offline
          M Offline
          Mazdak
          wrote on last edited by
          #4

          Thanks:) Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here."
          Wish You Were Here-Pink Floyd-1975

          1 Reply Last reply
          0
          • S sreejith

            Here is the sql stmt SELECT * FROM WHERE Name like 'M%' Sjt From Heaven

            M Offline
            M Offline
            Mazdak
            wrote on last edited by
            #5

            Thanks:) Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here."
            Wish You Were Here-Pink Floyd-1975

            1 Reply Last reply
            0
            Reply
            • Reply as topic
            Log in to reply
            • Oldest to Newest
            • Newest to Oldest
            • Most Votes


            • Login

            • Don't have an account? Register

            • Login or register to search.
            • First post
              Last post
            0
            • Categories
            • Recent
            • Tags
            • Popular
            • World
            • Users
            • Groups