What's the equivalen function of StrConv ([FirstName] , 3 ) in ACCESS in Sql Server 2000?

#1

HI,
i got a problem while using StrConv function in sql server.
My requirement is:-
suppose in a name field i have "jhon smith" Now i want to run a sql
which will give me the result like "Jhon Smith"--which means upper
case first.

Now i am running a query like below which is giving me "Jhon smith"
but i want "Jhon Smith".

SELECT [CustomerID] ,upper(left(firstname,1)) + lower(right(firstname,
len(firstname)-1)) AS [FirstName_] from my_table;

But the above query is not giving me the right result. Please
suggest...

Thanks
Hoque

#2

sohelcsc (AT) yahoo (DOT) com (Leader) wrote in message news:<b1a93c73.0307282218.74758994 (AT) posting (DOT) google.com>...

Quote:

HI,
i got a problem while using StrConv function in sql server.
My requirement is:-
suppose in a name field i have "jhon smith" Now i want to run a sql
which will give me the result like "Jhon Smith"--which means upper
case first.

Now i am running a query like below which is giving me "Jhon smith"
but i want "Jhon Smith".

SELECT [CustomerID] ,upper(left(firstname,1)) + lower(right(firstname,
len(firstname)-1)) AS [FirstName_] from my_table;

But the above query is not giving me the right result. Please
suggest...

Thanks
Hoque

You can find one possible solution here:

http://vyaskn.tripod.com/code.htm#propercase

Simon

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

What's the equivalen function of StrConv ([FirstName] , 3 ) in ACCESS in Sql Server 2000?

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

What's the equivalen function of StrConv ([FirstName] , 3 ) in ACCESS in Sql Server 2000? - 07-29-2003 , 01:18 AM

Re: What's the equivalen function of StrConv ([FirstName] , 3 ) in ACCESS in Sql Server 2000? - 07-29-2003 , 03:39 AM