Alphabet Number
Alphabet Number
how to seperate the alphabet and number from an alphanumeric value in database in a sql query in asp.net?
I have an alphanumeric id value like “com33″ in an access database column. While retrieving this data in a sql query I want to split “com” and “33″ seperately like the .Remove() method in asp.net .
You can do this a number of ways. The easiest is to use regular expressions. VB.NET / C# better supports regular expressions than SQL does, so I’d do this on the programming side.
Dim strInput As String = “code33″
Dim reAlpha As New RegEx(“[a-z]{1,}”, RegexOptions.IgnoreCase)
Dim reNumeric As New RegEx(“[0-9]{1,}”, RegexOptions.IgnoreCase)
Dim strAlpha As String = reAlpha.Match(strInput)
Dim strNumeric As String = reNumeric.Match(strInput)
How to find the best person to manage your money Five questions to ask your potential financial advisor
|
|
Cotton Alphabets and Numbers Scarf (India) $9.39 This fun alphabets and numbers scarf features durable cotton construction. Each beautiful scarf is handcrafted by artisans in India. |
|
|
Fondant ‘Alphabet and Numbers’ Cut-Outs (37/Pkg) $9.39 Fondant Cut-OutsAlphabet and numbers cut-out shapesWith cut-outs it is easy to make fun 3-D shapes for your fondant cakes and cupcakes |
|
|
Sizzix Bigz Alphabet Serif Essentials Numbers Set $27.49 A Bigz die cleanly cuts thick materials, including cardstock, chipboard, fabric, foam, magnet, leather, metallic foil, paper and sandpaper (in limited use). |
|
|
Sesame Street: Learning About Numbers/The Alphabet Jungle Game/Elmo`s World: Head to Toe (DVD) $17.81 Description not available. |
|
|
Thickers Chipboard Sprinkles Lavender Glitter Alphabet Stickers Sheet $6.76 These stickers help your scrapbooking and card making thoughts stand out with eye-popping glittery effects. This package contains two (2) sheets of alphabet, number, punctuation and symbol stickers. |