No announcements
Found 1142852 threads
-
0 VotesWHERE Alphanumeric = Numeric
that is alphanumeric with one that is numeric. I've tried converting, casting, and case statements, but I either get an overflow error or a big slap on the wrist by SQL Server ...Answered | 2 Replies | 5160 Views | Created by Ironworks_Scott - Thursday, December 20, 2007 2:32 PM | Last reply by Ironworks_Scott - Thursday, December 20, 2007 3:05 PM
-
11 Votes
SELECT only numeric part of string
Hi @ all, im forcing a problem where i have a alphanumeric string. I want to make a select where i only select the numeric part of the string. ...Answered | 7 Replies | 101153 Views | Created by BI4beginners - Wednesday, February 9, 2011 10:53 AM | Last reply by rhinomb - Thursday, April 11, 2019 7:43 AM -
0 Votes
importing data from excel
User-1474096950 posted i am importing data from excel where some fields are numeric some alphanumeric date etc if i ...Answered | 2 Replies | 14 Views | Created by Anonymous - Friday, March 16, 2012 6:00 AM | Last reply by Anonymous - Friday, March 16, 2012 7:23 AM -
0 Votes
Query to Select Only First Letter of Column
http://stackoverflow.com/questions/7157389/return-sql-rows-where-field-contains-only-non-alphanumericAnswered | 4 Replies | 125 Views | Created by Anonymous - Saturday, June 22, 2013 3:47 PM | Last reply by Anonymous - Monday, June 24, 2013 1:02 AM -
0 Votes
how to split a string
User-770998187 posted hi, If the pattern is same for every case like first 3 numeric then next alphanumeric then go with the solution provided ...Answered | 2 Replies | 20 Views | Created by Anonymous - Monday, November 23, 2009 6:38 AM | Last reply by Anonymous - Monday, November 23, 2009 8:10 AM -
0 Votes
IIF Expression help
contain 2 characters, one numeric and one alphanumeric : 4C , for example. If it is not null, I will also have to return only the numeric value and not ...Answered | 2 Replies | 3945 Views | Created by Pikker1981 - Thursday, November 13, 2008 5:27 AM | Last reply by Mary Lingel MSFT - Thursday, November 13, 2008 5:32 AM -
0 Votes
alphanumeric or numeric ID
User108863913 posted Hi,i am about to create a system thinking which is better for userId alphanumeric id or Numeric Id, i heared ...Answered | 1 Replies | 13 Views | Created by Anonymous - Saturday, August 20, 2011 12:06 AM | Last reply by Anonymous - Saturday, August 20, 2011 12:17 AM -
2 Votes
Create custom SQL Password Protection Policy
Data type: Numeric (4 Digits) - Can be zero Entry type: Text Box • Number of ...Answered | 2 Replies | 5795 Views | Created by SphinxxTelicath - Friday, July 27, 2012 6:27 PM | Last reply by RohitGarg - Saturday, July 28, 2012 4:33 AM -
0 Votes
alphanumeric validation
)) alert("only Alphanumeric."); else alert("Contains other than alpha ...Answered | 3 Replies | 8 Views | Created by Anonymous - Thursday, August 21, 2008 1:47 AM | Last reply by Anonymous - Thursday, August 21, 2008 9:29 AM -
0 Votes
The infamous "a duplicate attribute key was found while processing the dimension" error - What else can I do?
these replace it with an empty string. Use the SQL similar to the one below to find if you have anything else apart from space and alpha numeric ...Answered | 2 Replies | 2001 Views | Created by tvjripper - Friday, March 8, 2013 3:08 PM | Last reply by 'RajaSekhar' - Sunday, March 10, 2013 5:20 PM -
0 Votes
Formatting String
You can format numeric values the way you've shown, for example: Dim phoneNumber As String = 8005551234.ToString("(###) ###-####"Answered | 3 Replies | 3425 Views | Created by ashlesh.patel - Tuesday, February 23, 2010 12:02 PM | Last reply by ashlesh.patel - Wednesday, February 24, 2010 8:59 AM -
0 Votes
Problem with Range validator Control
User1414682904 posted Hello Friends, I want to usea RangeValidator Control which will validate my Password field where i want to check that if user enters less than 6Answered | 5 Replies | 22 Views | Created by Anonymous - Tuesday, April 6, 2010 1:24 AM | Last reply by Anonymous - Tuesday, April 6, 2010 2:48 AM -
0 Votes
Validations like Alphanumeric,Numeric
How we can Validate Data (Like Numeric,Alphanumeric) at Server Side without PostBack and Script.Answered | 2 Replies | 6 Views | Created by Anonymous - Monday, January 18, 2016 3:23 PM | Last reply by Anonymous - Tuesday, January 19, 2016 5:12 AM -
0 Votes
Pondering ASCII ordering in a string comparison
-alphanumeric characters in binary order ; followed by all numeric digits ; then followed by all alphabetic characters ...Answered | 3 Replies | 5221 Views | Created by Jamie Thomson - Thursday, October 14, 2010 8:09 AM | Last reply by Jamie Thomson - Thursday, October 14, 2010 10:38 AM -
0 Votes
FIELD AUTO NUMERIC ALPHANUMERIC
I need to know how convert a mixed field between text & numeric characters and do it autonumeric acording to the numeric part, it's possible with some input mask? which one ...Answered | 1 Replies | 4539 Views | Created by LAURA PLATA - Wednesday, June 7, 2006 9:31 PM | Last reply by Navajo - Wednesday, June 7, 2006 11:49 PM -
6 Votes
seperate numeric value from a alphanumeric
hi all, can i have solution for seperate numeric value from a alphanumeric \ example ...Answered | 3 Replies | 2888 Views | Created by zubair KDNL - Thursday, May 21, 2009 9:55 AM | Last reply by zubair KDNL - Friday, May 22, 2009 6:48 AM -
2 Votes
Are numerical primary keys more efficient than alphanumeric ones?
What types are you using for the numeric and the alphanumeric PK? Is it your clustering key as well? Where are you seeing the perf hit - querying or ...Answered | 7 Replies | 8718 Views | Created by JCEH - Saturday, April 18, 2009 11:34 PM | Last reply by JCEH - Wednesday, April 22, 2009 10:32 PM -
2 Votes
Order By mix alphanumeric numeric
by data would produce where the data with 0 came out first cause it's in numeric (ascii is smaller 0 = 060 and N =116) try this ...Answered | 4 Replies | 5259 Views | Created by sqlserverdotnet - Sunday, November 8, 2009 4:49 AM | Last reply by sqlserverdotnet - Sunday, November 8, 2009 11:43 PM -
0 Votes
Model validation not working with RegularExpression Attribute
User-1506157797 posted Hi, I am doing EmployeeIdent field validation to accept only ALPHA NUMERIC data using Regular expression in MVC application ...Answered | 1 Replies | 179 Views | Created by Anonymous - Wednesday, January 9, 2013 2:07 AM | Last reply by Anonymous - Wednesday, January 9, 2013 5:34 AM -
0 Votes
Validating Extended TextBox on LostFocus causes the validation infinite loop in wpf
Hi, I am writting an extended TextBox (class) to handle all validations like Numeric, AlphaNumeric, allow special chars...and I am going to use this in all my .xaml files through ot ...Answered | 2 Replies | 1517 Views | Created by VinayGaddam - Friday, July 17, 2015 5:57 PM | Last reply by Magnus (MM8) - Thursday, July 23, 2015 8:03 PM - Items 1 to 20 of 1142852 Next ›
No announcements
