Find all chars in table that are ASCII code 128 and Greater



Does anyone know how to query a field in a table where it contains an
ASCII code >= 128 - without looping through every field for every
record in table (using charindex)?

Ex of char I would like to find: ü which is char(252)



.



Relevant Pages

  • Re: fetching values returned by Stored Procedure by columnName and not
    ... yes, I am looping through the rows, but we are using SqlDataReader ... Following is the query in it. ... int fullName = offset + 1; ... int ShortName = offset + 2; ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: AUTOMATIC DATE/VALUE QUESTION...
    ... Do you really need to store the letter? ... computed field to that query to return the letter. ... The Chr function returns the character associated with a specific ASCII code ... figure out how to make the field insert the letter value that corresponds ...
    (microsoft.public.access.forms)
  • RE: Problem creating access Query on the fly
    ... I also found that by looping through all the ... 'Tables' in the database, some of the queries are found. ... I would Like to create a query in an Access database ...
    (microsoft.public.data.ado)
  • Re: Garbage Collection
    ... i mistakenly write there is no option looping, ... option but wat my query is that is this the only option, cant i dispose ...
    (microsoft.public.dotnet.framework.clr)
  • Re: Getting Record Count from SELECTs
    ... say you have a query as follows: ... type array is table of number index by binary_integer; ... 13 end loop; ... Looping, c%rowcount = 5 ...
    (comp.databases.oracle.server)

Loading