select * from Answers where AnswerName like '%No [DETAILS REQUIRED]%'   The above-given query does not return any results while there is an entry in the column "AnswerName " with the exact text as "No [DETAILS REQUIRED]"
I am trying to filter items with a stored procedure using like. The column is a varchar(15). The items I am trying to filter have square brackets in the name.  For example:  WC[R]S123456.  If I do a LIKE 'WC[R]S123456' it will not return anything.  I found some information on using the ESCAPE keyword with LIKE but I do not understand how to use it to treat the square brackets as a regular string.
I'm using LyX for technical documentation and want to automate the process of creating PDF files.  Within LyX, I can simply click the button "View PDF (XeTeX)", and LyX performs the whole build process for me: it creates a .tex file, does some bibliography magic, and uses XeTeX to create the final PDF file.  What I'm looking for is a way to call LyX from the command line and get the same result. So far, I've only managed to generate a plain .tex file (using --export-to xetex). However, when I run xelatex on the generated file, it keeps showing errors that don't occur when building using LyX. Is there a way to get LyX to do the work?  My system: Windows 7 64bit, LyX 2.1.0 Simplify a combinatorial sum Why is $\sum_{k=0}^n (_k^n) 2^k$ simplified as $3^n$ and not just $2^n$ ? The answer uses the binomial theorem as a solution: let $a=1$ and let $b=2$. So $1+2 = 3$. But since $1+2 = 3$ why do we not use $1+1 = 2$? Multiple authors in one row with refmark, multiple affiliations in separated columns in another row I wonder how we can list author names in the following format in LaTeX.   I have 5 authors with 3 different affiliations. I am trying to list all author names with refmark in one row, and 3 affiliations with refmark in another row, but each in one separated column. It should look like this:          author1{1} author2{2} author3{1} author4{2} author5{3}            {1}department      {2}department        {3}department               school              school              school               email                email              email   I did saw some papers that have the above format, but cannot search for any guideline. IEEE guideline suggests another way to list authors, but sadly it does not look that neat          author1{1} author2{2} author3{1} author4{2} author5{3}                         {1} department, school                               email                         {2} department, school                               email                         {3} department, school                               email Infiniteness of non-twin primes. Well, we all know the twin prime conjecture. There are infinitely many primes $p$, such that $p+2$ is also prime. Well, I actually got asked in a discrete mathematics course, to prove that there are infinitely many primes $p$ such that $p + 2$ is NOT prime. How to install latest Code::Blocks from tar.xz? How to install latest Code::Blocks using codeblocks_17.12-1_amd64_stable.tar.xz?  Software center has an old version and I am not able to configure. How to install? Why is there no documentation for installing? Add optional box for spam flags letting you say why you think it's spam , where a user had taken the time to look at the link on a post and realized that the post wasn't just off-topic, it was actually half-decently-disguised spam. So he flagged it as spam, and an overworked mod declined it, giving the questioner the benefit of the doubt. And we probably want mods to be giving the questioner the benefit of the doubt.  We also want to get rid of spam ASAP, and make the lives of mods easier. I'd like to suggest a feature the mod in question mused might be useful: An optional textbox where you can add a note saying why you think it's spam, so the mod can see it easily. In this case, the helpful user who went the extra mile could have written "Site linked doesn't relate at all to the question, instead solicits BitCoins" or similar.  One can leave a comment on the question, but:   People sometimes leave...unhelpful...comments on spam questions, and we don't want mods to have to take the time to read through them hoping for something useful It allows the user flagging the spam to do so and say why without calling attention to themselves publicly     Update: We may well want this for all flags, but in particular I had reason to want it for an NAA flag, so I've posted . I am trying to remove all files and subdirectories in a directory. I used rm -r to remove all files, but I want to remove all files and subdirectories, excluding the top directory itself.  For example, I have a top directory like images. It contains the files header.png, footer.png and a subdirectory.  Now I want to delete header.png, footer.png and the subdirectory, but not images.  How can I do this in linux? You are here, but where's here? I find the .youarehere a styling for the main navigation links causes the text to be a little difficult to read on the also-blue header background. Could we give it a little bit of background colour or something else that would provide more contrast?  For example:    which is the product of the following CSS*:  .nav ul li {     margin: -2px 10px 0 0;     padding: 5px; }  .nav ul li.youarehere {     background-color: rgba(0, 80, 112, 0.25);     border-radius: 5px; }  .nav ul li.youarehere a {     color: #A1E9FF; }   *For bonus points, also reduce the line height for the codeblocks! Money/Assets/Property that is earned through unethical sources is   called ?   Money that is earned through bad sources like corrupted politics, corrupted business, ransom money, stolen or theft money. What is such money called?  Is it bad money, black money. What is one particular name for it? Call to a member function prepare() on a non-object PHP Help I'm writing a contribution for a double-blind submission system.   Since I would like to supply more data than I could show on a small number of pages, I'm looking for a way to reference supplemental data in my manuscript, such as software scripts, figures or databases.  I could upload on GitHub, RPubs, Figshare and Zenodo, but all of these would expose my real user name (and I don't feel like making a throwaway e-mail account with a new repository for every anonymous publication that I intend to write).  Is there any way to get the above services to do what I want? Or is there a similar service that would allow anonymous hosting of research data?   It would be even better if I could later (e.g. after publication) declassify the information, with the link from the manuscript still being intact. I've seen plots of test/training error suddenly dropping at certain epoch(s) a few times during the neural network training, and I wonder what causes these performance jumps:    This image is taken from Kaiming He's Github, but similar plots show up in many papers. At work we were discussing this as my boss has never heard of normalization. In Linear Algebra, Normalization seems to refer to the dividing of a vector by its length. And in statistics, Standardization seems to refer to the subtraction of a mean then dividing by its SD. But they seem interchangeable with other possibilities as well.   When creating some kind of universal score, that makes up $2$ different metrics, which have different means and different SD's, would you Normalize, Standardize, or something else? One person told me it's just a matter of taking each metric and dividing them by their SD, individually. Then summing the two. And that will result in a universal score that can be used to judge both metrics.  For instance, say you had the number of people who take the subway to work (in NYC) and the number of people who drove to work (in NYC).   $$\text{Train} \longrightarrow x$$ $$\text{Car} \longrightarrow y$$  If you wanted to create a universal score to quickly report traffic fluctuations, you can't just add $\text{mean}(x)$ and $\text{mean}(y)$ because there will be a LOT more people who ride the train. There's 8 million people living in NYC, plus tourists. That's millions of people taking the train everyday verse hundreds of thousands of people in cars. So they need to be transformed to a similar scale in order to be compared.  If $\text{mean}(x) = 8,000,000$  and $\text{mean}(y) = 800,000$  Would you normalize $x$ &amp; $y$ then sum? Would you standardize $x$ &amp; $y$ then sum? Or would you divide each by their respective SD then sum?  In order to get to a number that when fluctuates, represents total traffic fluctuations.  Any article or chapters of books for reference would be much appreciated. THANKS!  Also here's another example of what I'm trying to do.   Imagine you're a college dean, and you're discussing admission requirements. You may want students with at least a certain GPA and a certain test score. It'd be nice if they were both on the same scale because then you could just add the two together and say, "anyone with at least a 7.0 can get admitted." That way, if a prospective student has a 4.0 GPA, they could get as low as a 3.0 test score and still get admitted.  Inversely, if someone had a 3.0 GPA, they could still get admitted with a 4.0 test score.  But it's not like that. The ACT is on a 36 point scale and most GPA's are on 4.0 (some are 4.3, yes annoying). Since I can't just add an ACT and GPA to get some kind of universal score, how can I transform them so they can be added, thus creating a universal admission score.  And then as a Dean, I could just automatically accept anyone with a score above a certain threshold.  Or even automatically accept everyone whose score is within the top 95%.... those sorts of things.  Would that be normalization? standardization? or just dividing each by their SD then summing? Prove no existing a smooth function satisfying ... related to Morse Theory How can I add four spaces before each lines of programs code in terminal I have setup a project of 250 frames with a flag and a wind force field. It works fine until I change the length of the project to 520 frames, then the flag is frozen after frame 250. There must be a simple way to change this. Thanks for any help. Regards, Daniel. How can I reject all changes in a Linq to SQL's DataContext? On Linq to SQL's DataContext I am able to call SubmitChanges() to submit all changes.  What I want is to somehow reject all changes in the datacontext and rollback all changes (preferable without going to the database).  Is this possible? Windows 7 shows red "X" on network icon, but I'm connected BASH script to set environment variables not working I've written the following script to set some environment variables when needed.  #!/bin/sh export BASE=/home/develop/trees echo $BASE export PATH=$PATH:$BASE echo $PATH   Below the command and the results I can see on my terminal: the script runs, but the variables are not set at the end.  ~$: ./script.sh /home/develop/trees /bin:......:/home/develop/trees ~$: echo $BASE  ~$:    What's wrong? Thanks in advance. Mirko Here, we suppose that $x,y\in\mathbb{R}$ and that $x^n=y^n$, where $n$ is odd. I want to prove that $x=y$.  Maybe we can use that $x^n-y^n=(x-y)(x^{n-1}+x^{n-2}y+...+xy^{n-2}+y^{n-1})$  So, it suffices to show that if $x^n=y^n$ then $x^{n-1}+x^{n-2}y+...+xy^{n-2}+y^{n-1}\neq 0$  Any hint?