Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Reverend Tom
Starting Member
2 Posts |
 Posted - 2005-03-09 : 19:40:15
|
| OOPS! I'm sorry, I meant to post this here, not in "General". At any rate, I have a simple query I built in Access, it goes like this:SELECT dbo_arcview.APPID AS [App ID], dbo_arcview.ARCID AS [ARC ID], IIf(IsNull([ARCID]),"",StrConv(([RC_Fst_Nm] & " " & [RC_Lst_Nm]),3)) AS [ARC Name]FROM dbo_arcview;My questions are how in the world to do the "strconv" function to get a title case name return from columns with all caps (like the RC_Fst_Nm and RC_Lst_Nm columns) and I'm totally lost on the "isnull" operator. Can someone please put me out of my misery? I've wasted a lot of time trying to work this out without any success. Thanks!RevTFSMMI'd call that Bold Talk for a One-Eyed Fat Man!I'd call that Bold Talk for a One-Eyed Fat Man! |
|
|
|
|
|
Formatting My T-SQL Query Results Like Access