Query to List the Alphabets in English

General
Enthusiast

Query to List the Alphabets in English

Hi All,

I got a idea to write a query to list all the aplphabets in english. I know its a useless one. but still thought of giving a try. except selecting the chars individually and doing union of the alphabets . i couldnt come up with a good idea. could someone write a query for me?
Tags (1)
2 REPLIES
Senior Apprentice

Re: Query to List the Alphabets in English

I would simpy use a table with all the neccessary characters in it.
It's like a calendar table, you fill it once and that's it.

Or you might write a Table UDF.

Btw, you post about Prime Numbers is very strange, it's only seen using RSS, i tried to move it, but i wouldn't work.
You should repost it, but change the subject line, did you include '/' before?
But i might answer right here, as it's exactly the same answer, put it in a table.
If you google for "Sieve of Eratosthenes" SQL you should find some queries to fill it.

Dieter
Enthusiast

Re: Query to List the Alphabets in English

Thank you Dieter. looks like we might need to create a stored procedure to find the same.