[R] Some SQL Challenges

[JoK LoQ]

Hi, 

Im trying to complete a list of jobs using SQL Querries and some "if else"
commands but im stucked in some steps. Could any of you give me some help?

-in COLUMN1 change the format 20JAN2000:00:00:00 to 20JAN2000 and exclude
every row that date is different from 20.
-extract the first character in COLUMN2 and creat COLUMN3 with that value
ex:
COL2,COL3
135,1
461,4
247,2
-in every row in which COL3=5, value in COLUMN4=value in COLUMN5
-create COLUMN7 where if COLUMN6="north" then COLUMN7 value="N" else COLUMN7
value="X"

Ill be grateful for any help, thnks
-- 
View this message in context: http://www.nabble.com/Some-SQL-Challenges-tp24795946p24795946.html
Sent from the R help mailing list archive at Nabble.com.