I cannot use the split_string function and I cannot alter the database to set the compatibility level to what I need.  I have a column with the following example values:  JohnDoe-123-fakestreet-02-2018-01-01-2018-12-03 SamSmith-ab1-concordia-16-2018-02-02-2018-11-03 JaneDoe-zxy-austin-11-2018-03-01-2018-03-16 HomerSimpson-999-Chicago-22-2018-04-01-2018-10-20 EricCartman-222-Madison-05-2018-05-01-2018-09-01   I need the 4th value in each row. I.e.:  02 16 11 22 05   How can I do this? Any suggestions?
Using SQL Server, how do I split a string so I can access item x?  Take a string "Hello John Smith". How can I split the string by space and access the item at index 1 which should return "John"?
How to reverse name and first name? Android reject incoming call The set of all finite subsets of the natural numbers is countable I need to prove that $\mathbb{R}\backslash\mathbb{Q} \sim \mathbb{R} $  Using Cantor-Bernstein, need to show an injection from $\mathbb{R}\backslash\mathbb{Q}$ to $\mathbb{R}$ and from $\mathbb{R}$ to $\mathbb{R}\backslash\mathbb{Q}$.    $\mathbb{R}\backslash\mathbb{Q}$ is a subset of $\mathbb{R}$ so only need to show injection from $\mathbb{R}$ to $\mathbb{R}\backslash\mathbb{Q}$ to complete the proof.    Possible injection: $f:\mathbb{R}\to \mathbb{R}\backslash\mathbb{Q}$ defined as $f(x) = \pi x$ if $x$ is not a multiple of $\pi$; otherwise $f(x) = \sqrt{2} x$.    Not sure if $f$ actually is an injection... This morning, I had eggs for breakfast, and I was looking at the pieces of broken shells and thought "What is the surface area of this egg?" The problem is that I have no real idea about how to find the surface area.    I have learned formulas for circles, and I know the equation for an ellipse; however, I don't know how to apply that.   The only idea I can think of is to put an egg on a sheet of paper and trace it, and then measure the outline drawn, and then try to find an equation for that ellipse and rotate that about the $x$-axis.  Now, my problem is how I can find the equation of the ellipse from the graph, and will my tracing method really be the edge of the egg?  Also, can I use the ? Will I have to use some techniques to solve the integral that are not covered in the ?  There has to be a better method for finding the surface area. Please, help me understand how to find the surface area of an egg; i.e., how to use my mathematical knowledge for something other than passing exams. Mathematical Prerequisites for QFT Recurrence relation for right-angled triangles stuck-together Bottom frame of listing appears on top of the next page How to ignore accent in SQLite query (Android) Will new Minecraft features appear in existing worlds? I'm a new Minecrafter, and was wondering if new updates are backwards compatible. Specifically, will the new "Adventure Update" features (Beta 1.8) appear in existing worlds created with Beta 1.7 and earlier? Or will I need to create a new world for this version? Which one sounds better? "of mine" or "my" My friend (or "a friend of mine"?) told me that anytime I need to express such expression, it's always better to say "of mine", because it sounds more naturally.  Like "two brothers of mine" rather than "my two brothers".  Is that true? Managing error with GPS routes (theoretical framework?) I'm looking for the appropriate theoretical framework or speciality to help me deal with understanding how to deal with the errors that the GPS system has - especially when dealing with routes.  Fundamentally, I'm looking for the requirements on the data and any algorithms to use to be able to establish the length of a trail. The answer needs to be trustworthy.  A friend of mine was the race director of a race which was billed as 160km but the Garmin watches everybody has makes it more like 190km+. It caused quite some grief at the finish line, let me tell you!  So my friend went back to the course with various GPS devices in order to remap it and the results are interesting.  Using a handheld Garmin Oregon 300 she got 33.7km for one leg. For the same leg on a wrist watch Garmin Forerunner 310xt it came out to 38.3km.  When I got the data from the Oregon it was obvious that it was only recording data every 90 seconds or so. The Forerunner does it every couple of seconds.  When I plotted the data from the Oregon I could see that it got confused by some switchbacks and put a line straight through them and a curve was made a little less.  However, I muse that the difference in the recording frequency is much of the explanation. i.e. by recording every couple of seconds the Forerunner is closer to the real route. However, there will be an amount of error because of the way GPS works. If the points recorded are spread around the real route randomly (because of the error) then the total distance will be larger than the real route. (A wiggle line going either side of a straight line is longer than the straight line).  So, my questions: 1. Are there any techniques I can use on a single dataset to reduce the error in a valid way? 2. Does my theory about the difference in recording frequency hold water? 3. If I have multiple recordings of the same routes are there any valid techniques to combine them to get closer to the real route?  As I say, I don't really know what to search for to find any useful science about this. I'm looking for ways to establish just how long a given piece of trail is and it is very important to people. An extra 30km in a race is an extra 5+ hours we weren't expecting.  As requested here is some sample data:       Thanks for any advice you can give. Consider these two ways of coining a name: 1) Bolzano's theorem, Rolle's theorem 2) the Poincare conjecture, the Kantorovich theorem. What is the difference between these ways, why do people choose one over the other?  My guess is that the main difference is when you put 's at the end of a name, you strictly imply that the theorem/conjecture was written by this very person (Bolzano wrote Bolzano's theorem). But when it is "the [Name] theorem/conjecture," it doesn't mean that the person which name is used actually created this thing, maybe he just inspired it (Poincare might have only inspired the Poincare conjecture but did not propose it).  Sometimes there is only one way: ; you can not call it hairy ball's theorem. Sending email with PHP from an SMTP server Lie bracket for Lie algebra of $SO(n,m)$ How does one show that the bracket of elements in the Lie algebra of $SO(n,m)$ is given by  $$[J_{ab},J_{cd}]  ~=~ i(\eta_{ad} J_{bc} + \eta_{bc} J_{ad} - \eta_{ac} J_{bd} - \eta_{bd}J_{ac}),$$  where $\eta$ has is the definite symmetric form with signature $(n,m)$? How to prove this inequality $\left|x\sin{\frac{1}{x}}-y\sin{\frac{1}{y}}\right|<2\sqrt{|x-y|}$? For any real numbers $x,y\neq 0$,show that $$\left|x\sin{\dfrac{1}{x}}-y\sin{\dfrac{1}{y}}\right|&lt;2\sqrt{|x-y|}$$ I found this problem when I dealt with . But I can't prove it. Maybe the constant $2$ on the right hand side can be replaced by the better constant $\sqrt{2}$? Thank you. BibTeX handling of the Dutch "van" name prefix with natbib Jet stream of water I would like to simulate a stream of water like the one in the picture, but I don't know how to simulate the fast-moving, white water. Should I use particles to simulate foam or is it much better to concentrate in the material properties? Thanks How prove this equation $\alpha=\aleph_{0}\alpha$ Question:     let $\alpha$ be a infinite cardinal , show that:   $$\alpha=\aleph_{0}\alpha$$   where $\aleph_{0}$ is the cardinality of the natural numbers is denoted aleph-null   this equation is from a book,and I can't prove it,and the author say this is important equation,and can't prove it.Thank you for you help My question is about one particular usage of static keyword. It is possible to use static keyword to cover a code block within a class which does not belong to any function. For example following code compiles:  public class Test {     private static final int a;         static {         a = 5;         doSomething(a);     }     private static int doSomething(int x) {         return (x+5);     } }   If you remove the static keyword it complains because the variable a is final. However it is possible to remove both final and static keywords and make it compile.   It is confusing for me in both ways. How am I supposed to have a code section that does not belong to any method? How is it possible to invoke it? In general, what is the purpose of this usage? Or better, where can I find documentation about this?