No announcements
Found 1158403 threads
-
0 VotesIgnore bad rows - not alphanumeric
Hi DarrenOD, According to your description, you want to filter out non-alphanumeric values for Date, Time and Site columns, except '/' and ':' and '.' for Date and Time ...Answered | 3 Replies | 1081 Views | Created by DapperDev_ - Wednesday, July 22, 2015 1:49 PM | Last reply by Katherine Xiong - Thursday, July 23, 2015 9:57 AM
-
0 Votes
randomizing a set group of alphanumeric characters
If you wanna create some random values for hash I would recommend Guid: Guid id = Guid.NewGuid(); if just some alphanumeric ...Answered | 1 Replies | 574 Views | Created by Kaptured - Friday, March 6, 2015 5:06 PM | Last reply by Val10 - Friday, March 6, 2015 5:21 PM -
1 Votes
How do I extract all alphanumeric characters upto first numeric character, from mixed string?
I need to extract all alphanumeric characters upto but excluding the first numeric character. eg if the string is 'AB01 5GH', I want to extract 'AB'.Answered | 9 Replies | 9069 Views | Created by Naz at ANSA - Monday, August 15, 2011 3:34 PM | Last reply by - Tuesday, August 16, 2011 6:15 PM -
1 Votes
Alphanumeric Serial Number for products
You could use a trigger, but the solution proposed here is probably the ...Answered | 8 Replies | 3657 Views | Created by Aakash Kelkar - Wednesday, June 5, 2013 1:20 PM | Last reply by Devon_Nullman - Thursday, June 6, 2013 12:21 PM -
0 Votes
How to produce an alphanumeric key?
How can I generate a 5 unit alphanumeric string and insert it into label.text?Answered | 4 Replies | 470 Views | Created by fokum8 - Thursday, December 11, 2014 3:33 PM | Last reply by Devon_Nullman - Thursday, December 11, 2014 6:25 PM -
0 Votes
I need Random Unique AlphaNumeric Code in series
Does it have to be Alphanumeric?Answered | 3 Replies | 571 Views | Created by Rai Danish - Thursday, February 25, 2016 5:52 PM | Last reply by Denis Radinski - Thursday, February 25, 2016 6:33 PM -
1 Votes
Retrieve maximum number from alphanumeric column in Sql
Hi Benniit, I see your original question here, and you said, the prefixes always start with 3 alphabets.Answered | 3 Replies | 1496 Views | Created by Benniit - Wednesday, January 27, 2016 1:25 PM | Last reply by Visakh16 - Thursday, January 28, 2016 5:39 AM -
0 Votes
How can we find the alphanumeric data in sqlserver?
union all select 'kj&98' union all select 'ad912' select data from @table & ...Answered | 7 Replies | 7040 Views | Created by anil yaaram - Wednesday, May 25, 2011 5:33 PM | Last reply by latha521 - Tuesday, May 31, 2011 2:09 PM -
0 Votes
ValidationExpression for alpha-numeric values
HI, Here is the expression, it will reject only alphabets and only numeric values, will validate alphanumeric values.Answered | 3 Replies | 7683 Views | Created by yogi3188 - Monday, November 26, 2012 6:26 AM | Last reply by Deepak Kalra - Wednesday, December 5, 2012 5:35 AM -
0 Votes
Generate a alphanumeric id for primary key min 4 digits
The 4 characters should be increased to 5, 6 , 7 when there is a deficit of available alphanumeric values that can be generated by the function that is generating the ...Answered | 11 Replies | 12093 Views | Created by Homer Technologies - Friday, March 28, 2014 1:18 AM | Last reply by --CELKO-- - Monday, July 23, 2018 4:42 PM -
0 Votes
ORA-01858: a non-numeric character was found where a numeric was expected
Hi H.James, According to your description, the issue is a non-numeric character was found where a numeric was expected while pulling data from an Oracle ...Answered | 3 Replies | 4303 Views | Created by H.James - Tuesday, March 10, 2015 2:35 AM | Last reply by Katherine Xiong - Thursday, March 12, 2015 8:00 AM -
0 Votes
Problem to keep Alphanumeric
Hi, I want to detect the given input string is alphanumeric, with only - and _ inside.Answered | 4 Replies | 447 Views | Created by Jackson_1990 - Friday, April 7, 2017 6:33 AM | Last reply by Viorel_ - Sunday, April 9, 2017 8:06 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 | 48 Views | Created by Anonymous - Saturday, August 20, 2011 12:06 AM | Last reply by Anonymous - Saturday, August 20, 2011 12:17 AM -
1 Votes
date between date1 and date2 keeps error with ORA-01858: non-numeric character found where a numeric was expected.
select * from <table> WHERE Date >= @Date1 and DateAnswered | 3 Replies | 2296 Views | Created by justbeginning - Monday, March 24, 2014 6:04 PM | Last reply by justbeginning - Monday, March 24, 2014 8:25 PM -
0 Votes
Lowest from a column which contains a alphanumeric string values
create table test ( pkid int identity(1,1) not null, id int , name varchar(10) ); insert into test values( ...Answered | 4 Replies | 746 Views | Created by MLTC - Tuesday, January 12, 2016 2:09 AM | Last reply by MLTC - Wednesday, January 13, 2016 3:59 AM -
0 Votes
Generate Automatic Alpha numeric registration ID Using Visual Web-part in SharePoint 2013.
Hi Rajiv, Did you want to achieve the automatic numeric ID in the C# code or SharePoint list ?Answered | 3 Replies | 907 Views | Created by Rajiv.fillip - Friday, November 11, 2016 10:26 AM | Last reply by Jerry Zy - Sunday, November 20, 2016 11:01 AM -
0 Votes
best datatype to store alphanumeric data sql2005
In the case of alphanumeric data, your main choices are char/nchar or varchar/nvarchar.Answered | 4 Replies | 19280 Views | Created by deti - Friday, May 27, 2011 11:34 AM | Last reply by Dan Guzman - Friday, May 27, 2011 12:12 PM -
4 Votes
IS NUMERIC
So, I think ISNUMERIC is interpreting or excluding the backslash consider the comma (',') as numeric.Answered | 5 Replies | 2273 Views | Created by Kapil.Kumawat - Monday, April 8, 2013 8:41 AM | Last reply by Krishnakumar S - Monday, April 8, 2013 10:04 AM -
0 Votes
varchar to numeric
From SQL Server 2012 on you can use: SELECT TRY_PARSE([Number] AS INT) AS Number FROM MyTable WHERE Number IS NULL -- ...Answered | 6 Replies | 1153 Views | Created by sakurai_db - Friday, August 22, 2014 8:56 AM | Last reply by Erland Sommarskog - Friday, August 22, 2014 11:40 AM -
1 Votes
ORDER BY for alphanumeric
('PA-304 A'), ('PA-306 A'), ('PA-308 A'), ('PA-308 B'), ('PA-308 C'), ('PA-309 A'), ('PA-309 B'), ('PA-309 C'), ('PA-310 A'), ('PA-312 A'), ('PA-312 ...Answered | 18 Replies | 1045 Views | Created by mmmtbig - Thursday, February 19, 2015 6:03 PM | Last reply by mmmtbig - Wednesday, February 25, 2015 10:40 PM
No announcements
