I have a table where there are 2 columns: optionValues and optionNames . optionNames contains the text of a combobox and optionValues the value of each text , both are separated with ~. For example :  optionValues | optionNames    0~1       |   male~female   What I am trying is to create a function which will take as argument an optionValue and will return the optionName. Using the example above:  fn.GetOptionName(1) --will return `female`   How I can separate the values and get back the correct one?  This is what I started with but it wont work because it doesn't separate the values:  select @on = OptionNames from dbo.Table  where tablename = @tablename and fieldname = @fieldname and optionvalues = @fieldvalue   (I cannot change the db schema no matter if its good or bad)  EDIT  Found this function which returns a substring in a specific position:
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"?
tag:* links incorrectly when using Save And Copy Profile To All Stack Exchange Accounts The  tag in my Stack Exchange profile links to different sites depending on where it's being viewed:  Profile on StackOverflow:  [tag:CSS] =&gt; https://stackoverflow.com/questions/tagged/css   Profile on StackExchange:  [tag:CSS] =&gt; https://stackexchange.com/questions/tagged/css   Profile on CodeReview:  [tag:CSS] =&gt; http://codereview.stackexchange.com/questions/tagged/css    I'd like to have these all link to https://stackoverflow.com/questions/tagged/css. You can ; why not add the ability to specify the site with tags? &lt;!-- tag: stackoverflow --&gt;[tag:css] &lt;!--tag: meta --&gt;[tag:feature-request]  The current behavior also cause a bug on my :    All tags send me to find a Panda aka 404 Page Not Found. What is the right first step to take when integrating $1/(2+ \sin x + \cos x)$? I want a hint on this following integral. I don't know the first step, do I do $u$-sub. or do I use trig. sub or something?  $$\int \frac{1}{2+ \sin x + \cos x} ~\mathrm{d}x$$ Evaluating the integral $\int_0^{\frac{\pi}{2}}\log\left(\frac{1+a\cos(x)}{1-a\cos(x)}\right)\frac{1}{\cos(x)}dx$ How to get IOS "tossing feature" in Wolfram IOS Player to work in Mathematica I am thinking of buying a digital SLR camera. What things should I be looking for? "A friend of my father" vs. "a friend of my father's" — which one is right? Why? I have seen them both in my reference book, which is written by a native speaker. I wonder why there are two different phrases to describe the same meaning and am looking forward to some reasonable details to explain why this is so. What *is* an Artificial Neural Network? As we delve into  literature, we get to identify other methods with neuromorphic topologies ("Neural-Network"-like architectures). And I'm not talking about the . Examples are given below.  Then, it makes me wonder: what is the definition of an artificial Neural Network? Its topology appears to cover everything.    Examples:  One of the first identifications we make is between PCA and a linear Autoencoder with tied-weights in the encoder and decoder and thresholded activations in the bottleneck layer.  Also, a common identification is done between linear models (logistic regression in special) and a Neural Network with no hidden layer and a single output layer. This identification opens several doors.  . ? ANN. Gaussian Process? ANN (with single hidden layer with infinite hidden units).  And so, just as easily, we can incorporate arbitrary regularized versions with specialized loss functions of these algorithms into a Neural Network framework.  But the more we dig, the more similarities appear. I just stumbled into , which makes the identification of a specific ANN architecture with decision trees, allowing these to be learned by ANN methods (such as Gradient Descent backpropagation). From this we can construct Random Forests and Gradient Boosted Decision Trees from solely Neural Network topologies.  If everything can be expressed as an Artificial Neural Network, what defines an Artificial Neural Network? Do save bonuses stack from multiple magic items in AL? I play in Adventurers League and have a character that has a +1 Ring of Protection, which gives +1 to AC and saves. I also have a Stone of Good Luck which gives a +1 to saves and ability checks.  If I equip both items and my base Dex save is +4, would it become +6 due to receiving both bonuses, or +5 with just one? I can't find much in the PHB or Google to answer this. I'm having trouble figuring out how to iterate over map layers. I can access the currently highlighted layer in the table of contents via iface.activeLayer() but I want my code to operate on all layers.  I don't see anything in the API that provides easy access to this functionality and couldn't find a good online example but maybe I missed something? How to retrieve multiple rows from database in PHP Example of vector space such that $cv = 0$ where $c \ne 0$ and $v \ne \vec{0}$ Is there an example of a vector space $V/F$ such that $0 \ne c \in F$, $\vec{0} \ne v \in V$, but $c \cdot v = 0 $?  I couldn't think of an example. Test to see if the title length requirement can be circumvented by appending lots of dots. Is it possible to plot a graph of any shape? In school, I have learnt to plot simple graphs such as $y=x^2$ followed by $y=x^3$.  A grade or two later, I learnt to plot other interesting graphs such as $y=1/x$, $y=\ln x$, $y=e^x$. I have also recently learnt about trigonometric graphs and circle equations. In the internet, I have seen users posting graphs of different shapes like a heart-shaped graph and a Batman logo-shaped graph. I am sure there are numerous more graphs that I have yet to see. Seeing that the graphs can be shaped into shapes like the Batman logo and a heart brings me to my question: Is it possible to plot a graph of any shape regardless of its complexity? Perhaps, shaped into an outline of a person or a landmark? Why or why not? Why do some Debian packages have a "+deb7u2" suffix? I figured the "7u2" part stood for "Debian 7.2" (aka "wheezy"). But I'm wondering if anybody knows the official answer as to why some packages have it and others do not.  Example:   The only time "+deb7u2" is appended to the version is when the package gets put in the "stable" release. Does this mean that's a "tag" to indicate a checkin to stable from another repo? In MTG, what happens when a player loses in multiplayer? How do you remove the ability for a user to make a comment or post on a page? I am building a new website on Wordpress, and all my pages have the add comment box at the bottom. I wish fo rthis to be removed from pages such as Home, Contact Us, About etc etc, but want it to remain on the blogs and galleries.  I have read  but do not really understand what this means to do. is there an easier way to do it. I do not have  under Settings -> Discussions. How do you persuade an organization to value UX? UX is such an underrated field in a lot of industries. I wonder how companies consider employing UX designers and even heavily valuing their suggestions. Some big companies happen to see the light and invest in UX, and that keeps them on top of others. However, UX people rarely make it to the top management. In Don Norman's talk (  ), out of so many UX people (I don't know exactly), only two were vice presidents. I assume that there are even less influential UX designers in developing countries, and that's what makes it even harder for people like me. In the same talk, Don Norman suggested that UX designers should approach their executives like marketing people, showing how investing in something will affect profit. Perhaps, it's the best thing to do but it has to be mastered for it to be executed successfully.   I'm a fresh grad and am looking for a job. I think, working for a company with a more conventional job description would be the way to go. When I'm already influential enough, I'll go up to the executives and show them how UX will improve sales (in whatever industry it is. I just want to do UX)  Do you do UX as consultants or are you employed? How do you persuade companies to invest in UX? Are you lucky enough to be employed by people who you didn't have to persuade to value UX? Why null cast a parameter? What is a good introductory book on quantum mechanics? Why was River Song so slow?