Search results for query: *

Thanks, that is perfect. Cornelius

Actually, I meant how to find *numbers* i.e. *records containing only digits*. Sorry for the confusion.

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'...

Thanks a lot Feherke. I will try to explore the perl option. Cornelius

Thanks for the post. I understood that this is only a simulated multi-dimensional array and in reality it is a single dimensional array with indexes concatenated into a single one. However, in this case, I might not need multi-dimensional arrays, just brake the single index into substrings...

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...

Thanks for the link. I understand from that post that there are three levels of collation and it is possible to change the collation at any of these levels: - server collation - database collation - column collation I even found how to make the collation case sensitive at the column level: you...

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

Thanks a lot PHV, this is exactly what I need. 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...

Thanks a lot! Cornelius

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...

Thanks a lot – it is really great to be able to get help from knowledgeable people like you! I applied PHV’s modification and feherke’s function (and a couple of other easy changes). Now I can run the script, get an output file and the result looks good. Cornelius P.-S. I consider posting the...

Thanks a lot again. All the syntax error messages disappeared but a new one appeared instead: awk: iprjen.awk:117: (FILENAME=iprjen.uni FNR=1) fatal: attempt to use scalar `a PrintArray' as array Here are lines 112-117: # if we have a print array, process it first if (...

Thanks a lot for the suggestion: I used coma and single pair of brackets instead of the double pair of brackets and the two error messages disappeared. I still get some errors however, here are the next two (the fifth and sixths are the same as the third): awk: iprjen.awk:306...

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...

Thanks, the case sensitive search works now fine. Cornelius

Thanks, I replaced = with LIKE and it works fine! Cornelius

Hi, Thanks a lot, it resolved half of my problem: for any specific character, I can get the total number of occurrences by creating a count table with the above query and adding a Sum(count.NumberOfA) etc. query. It even works for non-ASCII characters. However, I still have two issues: 1) I...

Hi, How can George’s code be combined with wildcards? I tried the following but it did not return any result: Select * From @Temp Where Data Collate SQL_Latin1_General_CP1_CS_AS = 'Blu%' Any idea? Cornelius