C#

Syed Shahid Hussain wrote:

I want casting like " Select cast(ID as varchar(20)) as ID from [Sheet1$] ".

Can we do that in Excel Query string.

Bardy85 wrote:

Are you trying to do this is SQL, or in code?

Dictionary<char, List<int>> list = new Dictionary<char, List<int>>();

foreach(char c in list.Keys)
   list[c].Add(...); // issue a second query here

static void Main(string[] args)
{
    List<string> match = new List<string> { "a", "b", "apple", "c", "grape" };
    List<string> fruits = new List<string> { "apple", "passionfruit", "banana", "mango", "orange", "blueberry", "grape", "strawberry" };

    var query1 = from matchList in match
                 select matchList;


    var query2 = from myFruits in fruits
                join matchList in query1 on myFruits equals matchList
                select myFruits;

    foreach (var item in query2)
    {
        Console.WriteLine(item);
    }
    Console.Read();
}</string></string></string></string>