Search results for query: *

Hello, I would like to find all the records that contain only digits. So far, I have this: SELECT * FROM tmp1 WHERE (word LIKE N'[0-9]') It returns only ten results, each containing a single digit. What I need is to find all the records containing only digits, like '378'...

Hi, I use gawk but need to run an old awk script, written for the tawk compiler (http://www.tasoft.com/). The syntax is slightly different, for instance, they declare multi-dimensional arrays like this: ary[word][dialect][24] = "A"; This does not compile under gawk, but I can easily convert...

Hi, Our Microsoft SQL Server was installed as case insensitive by default. How to change the default value to case sensitive (without re-installing it again)? I hope we just need to change a simple setting somewhere… Cornelius

Hi, I would expect the following query to show identical records from t1 and t2: SELECT t1.f1, t1.f2 FROM t1 INNER JOIN t2 ON (t1.f2 = t2.f2) AND (t1.f1 = t2.f1); It works fine when none of the fields is empty. However, if both tables contain the same value in f1 but f2 is empty, the query...

When you click on File/Get External Data/Import and you choose a text file, the Import Text Wizard appears. You click on Advanced and can set up an Import Specification and save it. I guess this is saved into a text file. Where is that text file? I would like to document the process this...

Hi, I need to run an awk script written by someone else seven years ago and probably working fine in that configuration. Now I receive six "syntax error" messages (no other errors), the first two are: awk: iprjen.awk:72: aFtagHierarchy[$1][ awk: iprjen.awk:72...

Hi, I have a column containing words. I would like to list all the characters and count how many times each character occurred in the entire column (not per word/record). There are some non-ASCII characters. Do you have any SQL query or script to do this? Thanks, Cornelius

Hi, Do you know how to make a case sensitive search on SQL Server? I was thinking about converting the words to Unicode via a VB Script. Does any of you have such a script? Thanks, Cornelius

Hi, I have a column containing words and would like to count how many times each character occurred. There are some non-ASCII characters. Do you have any idea how to do this? Is there an SQL query or would it need a (VB) Script? Thanks, Cornelius

Hello, The following line works fine in my script: split(t, words, " "); It splits/divides the string ‘t’ (actually a text) into words and puts them into a table called ‘words’. I would like to change the separator from space to (space AND question mark AND exclamation mark). I guess the...