CELKO (12/11/2012)
In COBOL, the display and the internal format of data was the same. Each field had a PICTURE clause to define it. Your question makes sense only in that context.
COBOL was never mentioned, and you are purposefully misrepresenting and misreading the original question. The question is about a specific character existing in a field. anything else you read into the question is nonsense. Worse, your strained comparison to try and bring a PICTURE clause into the question is just plain ridiculous.
This is SQL; columns are abstract data types that can be implemented any way at all. As with any -- repeat, ANY -- tiered architecture, all of the display formatting is done in a presentation layer. NEVER in the database.
the original poster never mentioned anything about formatting the data. he is clearly simply trying to find the substring of a string containing a specific character.
This is not a little miscegenation; this is the basis of C/S. You are the flat earth kid in a geography class.[/quote]
why not call him a witch and call for burning him at the stake? your constant attempts to belittle posters is worse than unprofessional. You are an embarrassment to the SQL community as a whole, and i wish you simply stop posting. Look for yourself: in your last, say 50 posts, have you helped anyone, at all? You simply went on diatribes about issues, but made sure to add a few insults along the way.
I
Lowell