Proper Case

[gkrenton]

Yes I'm back
and am now trying to determine what the equivalent Informix SQL statement is to show a result in a proper 'case' format.
In access it's
StrConv([web_color_desc],3)
I'm not having much luck finding the equivalent statement for Informix but I'd assume there must be something?

Thanks

- Gina

 

[vpshriyan]

Hi,

Can you elaborate bit more on this issue? What do you mean by proper 'case' format? In the quoted example what do StrConv([web_color_desc],3) function return?

Regards,
Shriyan

 

[PHV]

vpshriyan, the example given is VBA code.
Proper case means all words in lowercase but the initials:
"Example Of String In Proper Case"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[gkrenton]

PHV is correct - I'm trying to extract data from an informix DB that typically is created in upper case & would prefer to see it extracted in proper syntax
So instead of ASSORTED it would extract as Assorted.

Thanks
- Gina

 

[vpshriyan]

Hi,

The SQL statement below works fine to me in IDS v9.4 UC4

select initcap('this is an example') from systables where tabid=1;

Regards,
Shriyan
"Change is the only constant thing in a process"

 

[gkrenton]

Sorry for the response of a Thanks - that was the mystery code I needed.

- Gina