Click here to Skip to main content
15,887,135 members
Home / Discussions / C#
   

C#

 
GeneralRe: Parse XML Sibling Pin
Richard Deeming9-Apr-15 10:02
mveRichard Deeming9-Apr-15 10:02 
AnswerRe: Parse XML Sibling Pin
surya tri13-Apr-15 2:21
surya tri13-Apr-15 2:21 
Questiongenerate a sequence of number prefixed with a character Pin
Jimmy-IN8-Apr-15 23:17
Jimmy-IN8-Apr-15 23:17 
AnswerRe: generate a sequence of number prefixed with a character Pin
Freak308-Apr-15 23:26
Freak308-Apr-15 23:26 
AnswerRe: generate a sequence of number prefixed with a character Pin
Pete O'Hanlon8-Apr-15 23:29
mvePete O'Hanlon8-Apr-15 23:29 
GeneralRe: generate a sequence of number prefixed with a character Pin
Jimmy-IN8-Apr-15 23:35
Jimmy-IN8-Apr-15 23:35 
GeneralRe: generate a sequence of number prefixed with a character Pin
Eddy Vluggen9-Apr-15 0:23
professionalEddy Vluggen9-Apr-15 0:23 
AnswerRe: generate a sequence of number prefixed with a character Pin
V.9-Apr-15 2:08
professionalV.9-Apr-15 2:08 
In addition to what Eddy Vluggen mentioned. I assume that "a" prefix has a purpose. Else it would not be necessary. Therefore other prefixes are possible too ("b", "c", "helloworld", ...).

you could save the prefix in another column, effectively allowing you to filter on it.
if the number in itself is unique I would use that as primary key, however if the numbers are only unique in the prefix itself, I would create a seperate sequence for the primary key and two columns "prefix" and "sequencenumber".

In addition, if you save in multiple columns this also allows more advanced sorting, grouping, counts, etc...

hope this helps.
best of luck.
V.

(MQOTD rules and previous solutions)

QuestionGet listbox text to show in richtextbox + custom text Pin
Googooli868-Apr-15 22:52
Googooli868-Apr-15 22:52 
Answer[REPOST] Pin
Sascha Lefèvre8-Apr-15 23:35
professionalSascha Lefèvre8-Apr-15 23:35 
QuestionHow do I filter PPID between oPsType.PPIDFrom and oPsType.PPIDTo, and pay_type in oPsType.PAY_TYPE Pin
Member 115045458-Apr-15 9:42
Member 115045458-Apr-15 9:42 
AnswerRe: How do I filter PPID between oPsType.PPIDFrom and oPsType.PPIDTo, and pay_type in oPsType.PAY_TYPE Pin
Mycroft Holmes8-Apr-15 14:19
professionalMycroft Holmes8-Apr-15 14:19 
QuestionToday's Async Question #2 Pin
Kevin Marois8-Apr-15 8:35
professionalKevin Marois8-Apr-15 8:35 
QuestionAnother Async Question Pin
Kevin Marois8-Apr-15 8:18
professionalKevin Marois8-Apr-15 8:18 
AnswerRe: Another Async Question PinPopular
Richard Deeming8-Apr-15 8:27
mveRichard Deeming8-Apr-15 8:27 
GeneralRe: Another Async Question Pin
Kevin Marois8-Apr-15 8:30
professionalKevin Marois8-Apr-15 8:30 
GeneralRe: Another Async Question Pin
Mycroft Holmes8-Apr-15 14:22
professionalMycroft Holmes8-Apr-15 14:22 
Question{0} Pin
Member 115906308-Apr-15 3:04
Member 115906308-Apr-15 3:04 
AnswerRe: {0} Pin
harold aptroot8-Apr-15 3:35
harold aptroot8-Apr-15 3:35 
AnswerRe: {0} Pin
Sascha Lefèvre8-Apr-15 3:49
professionalSascha Lefèvre8-Apr-15 3:49 
Questionconverting given hex value into rgb Pin
Member 115353748-Apr-15 1:25
Member 115353748-Apr-15 1:25 
GeneralRe: converting given hex value into rgb Pin
harold aptroot8-Apr-15 1:44
harold aptroot8-Apr-15 1:44 
AnswerRe: converting given hex value into rgb Pin
OriginalGriff8-Apr-15 4:38
mveOriginalGriff8-Apr-15 4:38 
JokeRe: converting given hex value into rgb Pin
Richard Deeming8-Apr-15 8:04
mveRichard Deeming8-Apr-15 8:04 
GeneralRe: converting given hex value into rgb Pin
OriginalGriff8-Apr-15 8:17
mveOriginalGriff8-Apr-15 8:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.