dynamically build Select Case statement from a table

[HRHK]

How can I dynamically build Select Case statement from the table?

eg. if t_customer table has 4 customers where first_name are:
Sam
David
Mike
Jeremy

Then I would like to build select case statement for these 4 persons.
i.e. Select case f_name

case "Sam"

case "David"

case "Mike"

case "Jeremy"

End Select

I would be grateful for any suggestions. Thanks.

 

[ThatRickGuy]

What do you want to do depending on the name?

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[chrissie1]

I think you want to do this in sql.

Christiaan Baes
Belgium

I just like this --> [Wiggle] [Wiggle]