Re: how to make case sensitive query

From: Uri Dimant (urid_at_iscar.co.il)
Date: 11/29/04 

Date: Mon, 29 Nov 2004 09:18:28 +0200

Suresh
There are some examples
create table ABCD
(
  [id]smallint not null,
  description varchar(20) null
)
insert into ABCD([id],description)values (1,'DFh2AcZ')
insert into ABCD([id],description)values (2,'dHZ3')

)

SELECT description FROM ABCD where charindex(cast('H' as
varbinary(20)),cast(description as varbinary(20)))> 0

SELECT description
FROM ABCD
WHERE description ='dhZ3'COLLATE Latin1_General_BIN

SELECT description
FROM ABCD
WHERE charindex('h',description COLLATE Latin1_General_BIN)>0

"Suresh" <Suresh@discussions.microsoft.com> wrote in message
news:AA1AC827-DA0D-421E-9118-662848C0AB7C@microsoft.com...
> I need to retrive the a case sensitive value from a string.
> like select All_Capital_Alphebets("This Is My String")
> Expected result : "TIMS" (ie all capital letters from the string.
>
> How can i achieve this.
>
> Thanks in advance
>
> Suresh

Relevant Pages

  • RE: "Object Required" error when calling .Net DLL
    ... and in your VBA code, you try to assign a string value to it which is not an ... CC.Value = "abcd" ... Maybe you can change the Value Property to String? ... Public Class ComClass ...
    (microsoft.public.excel.programming)
  • permutation algorithm
    ... If this is my string 'abcd', ... I figure I need an incremental counter and a decremental counter and a ... without even the implied warranty of merchantability ...
    (microsoft.public.scripting.vbscript)
  • Re: how to count if cell "contains" a word
    ... abcd is a substring. ... Function StringCount(rg As Range, str1 As String, str2 As String) As Double ... To enter this UDF, ... not count, for example, abcde when looking for abcd. ...
    (microsoft.public.excel.worksheet.functions)
  • Repost: DrawString and ellipsis problem ... please help
    ... I have a rectangle with a string inside and the user can drag the mouse ... a string "abcd" is progressively displayed as: ... abc... ...
    (microsoft.public.dotnet.framework.drawing)
  • Re: "Object Required" error when calling .Net DLL
    ... AFAIK, a .Net object maps to a COM variant, so I have tried: ... Unfortunately I can't just have the property declared as a string due ... On May 2, 2:04 pm, Vergel Adriano ... CC.Value = "abcd" ...
    (microsoft.public.excel.programming)