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 Offline
    A Offline
    asha_s
    wrote on last edited by
    #1

    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 C B C 4 Replies 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

      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
            • 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
              #6

              thanks

              1 Reply 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
                #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