SQL Query Help

[PaulSharma]

Hi I want to write SQL query, where in i want to select all records where name= (A or B or C) but if i select "All " it should give me all records

This is my try ... please modify

Select *
From Records
Where name=froms!main!user ..... this is if i select only one name

but what do i do if i want all records, if i select ALL from the menu there will be no user name named 'ALL'

 

[Liv Manto]

Create an IF then else

if all then
Select *
From Records