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 know jest the first later how can i write my sql

i know jest the first later how can i write my sql

Scheduled Pinned Locked Moved Database
databasehelpquestion
11 Posts 6 Posters 2 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.
  • A asha_s

    hi :-D :-D i want to look for feature start with leter 'b' can i write select * from mytable where feature like 'b%' i want to make sure before starting so please help me

    L Offline
    L Offline
    leckey 0
    wrote on last edited by
    #2

    1. Please check your English. Your message title makes no sense. 2. Part of programming is making mistakes and learning from them. We are not here to hold your hand so you can always get it right the first time.

    New feature! Scroll down to see CP offenders! Upcoming blogs: "My cats are evil." http://craptasticnation.blogspot.com/[^]

    1 Reply Last reply
    0
    • A asha_s

      hi :-D :-D i want to look for feature start with leter 'b' can i write select * from mytable where feature like 'b%' i want to make sure before starting so please help me

      C Offline
      C Offline
      Chris Meech
      wrote on last edited by
      #3

      you can write that.

      Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] Donate to help Conquer Cancer[^]

      A 1 Reply Last reply
      0
      • A asha_s

        hi :-D :-D i want to look for feature start with leter 'b' can i write select * from mytable where feature like 'b%' i want to make sure before starting so please help me

        B Offline
        B Offline
        Blue_Boy
        wrote on last edited by
        #4

        If you want to get all values which starts with letter b then use that query.


        I Love T-SQL Don't torture yourself,let the life do it for you.

        A 1 Reply Last reply
        0
        • A asha_s

          hi :-D :-D i want to look for feature start with leter 'b' can i write select * from mytable where feature like 'b%' i want to make sure before starting so please help me

          C Offline
          C Offline
          Christian Graus
          wrote on last edited by
          #5

          Why would you ask this and not just try it ?

          Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

          A A 2 Replies Last reply
          0
          • B Blue_Boy

            If you want to get all values which starts with letter b then use that query.


            I Love T-SQL Don't torture yourself,let the life do it for you.

            A Offline
            A Offline
            asha_s
            wrote on last edited by
            #6

            thanks

            1 Reply Last reply
            0
            • C Chris Meech

              you can write that.

              Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] Donate to help Conquer Cancer[^]

              A Offline
              A Offline
              asha_s
              wrote on last edited by
              #7

              thanks

              1 Reply Last reply
              0
              • C Christian Graus

                Why would you ask this and not just try it ?

                Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

                A Offline
                A Offline
                asha_s
                wrote on last edited by
                #8

                hi because my program not ready

                A C 2 Replies Last reply
                0
                • C Christian Graus

                  Why would you ask this and not just try it ?

                  Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

                  A Offline
                  A Offline
                  Adeel Chaudhry
                  wrote on last edited by
                  #9

                  May be because its complex and time taking ;)

                  Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.

                  1 Reply Last reply
                  0
                  • A asha_s

                    hi because my program not ready

                    A Offline
                    A Offline
                    Adeel Chaudhry
                    wrote on last edited by
                    #10

                    Are you coding Management Studio? :~

                    Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.

                    1 Reply Last reply
                    0
                    • A asha_s

                      hi because my program not ready

                      C Offline
                      C Offline
                      Christian Graus
                      wrote on last edited by
                      #11

                      OK - so why worry about SQL if you're incapable of running any ? I guess you need to wait until you can test your code. Or use a database with client tools.

                      Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

                      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