Browse 540 attributed reviews, viewable separately for our classroom and online training

Details for Onette

Onette has participated in the following threads:

Added by Onette on 22 Feb 2020 at 13:19

Select EventName, EventDetails, EventDate
From  tblEvent
Where (CategoryID = 4 or CountryID in (8,22,30,35) or lower (EventDetails) like '%water %') 
and Year(EventDate)>1970   ---- the year is extracted with function YEAR() 
 

Added by Onette on 22 Feb 2020 at 17:20

select EventName as What, EventDetails from tblEvent
Where  lower(EventName) like '%Teletubbies%' or  lower(EventName) like '%Pandy%'

Added by Onette on 22 Feb 2020 at 17:49

Select *, len(EventName) as Lenght  from tblEvent
Order by Lenght