A "sadistic" young woman has been caged for life for a homophobic killing after she kicked a father to death before laughing at her lifeless victim.
Dionne Timms-Williams, who was 16-years-old when she punched and kicked Dr Gary Jenkins, was seen cackling by a witness during the horrific attack in July last year.
Dr Jenkins, a 54-year-old, dad-of-two, was assaulted in the shadow of a historic castle and was seen and heard on audio CCTV begging for help as he was beaten to death. Read More...
I have a string "Rj 0001 201410212014110301G 20141103ioR4564534 N20141021N 11R" in the table. I would like to return the value "R4564534" from the string.
The query I use is:
select SUBSTR(columnX,POSITION('R' IN columnX),8);
but it returns "Rj" instead of "R4564534".
The result I'd like to get is "R4564534".
1 Answer Is it actually 'Rj', only two characters? Not 'Rj 0001 '?
There's already an 'R' in the first position of your string, of course it's not starting with the 2nd 'R'. Read More...
Biography Troy Kenneth Aikman (born November 21, 1966), who is known as Troy Aikman, is a professional American football quarterback and sportsperson. He spent 12 seasons with the Dallas Cowboys in the National Football League (NFL).
After transferring from Oklahoma, he won the Davey O’Brien Award at UCLA and was chosen first overall by the Cowboys in the 1989 NFL Draft.
Troy Aikman, the Cowboys quarterback with the longest tenure, was chosen for six Pro Bowls and won three Super Bowls between 1992 and 1995. Read More...