have you tried replacing using ascii ?! 34 for 39 or some such ?!

You can add as many CASEs as you want (as previous poster said)...the syntax will be something like this:

SELECT Known_as =

CASE

WHEN LEN(Known_as) = 0...

Here's what my research yielded:

Unfortunately, there is no easy way to alter or modify a user defined data type. To modify a user defined data type, follow these steps:

...

Have you tried removing the "exec" from your report recordsource - either in design-property settings or in code ?!

Can you not use windows api - Private Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" _

(ByVal lpBuffer As String, nSize As Long) As Long to get...

Maybe I'm completely missing something here...I've been using OR operators to fetch me a resultset where either condition specified has been true - so if I specify 2 conditions like...

Will check all.

For my part I always enjoy Steve's articles because they are so exceedingly well written - I have 3 separate databases - one is production and there are 2 development/test...

Yes - this is exactly what happened to me the first time except I didn't pay much attention to it...the funny thing is that when I right-clicked the first time...

I ABSOLUTELY LOVE this site...I didn't know of the taskpad existence either (which's why I "hang out" at this site - to see what I can learn)...what's even "cooler" about...

Yes - it does help thank you! I found the actual script under "backup database" in the books online - but this whole feature is so downplayed that I guess...

Sorry - I don't know that this is possible as well & I'd be interested in knowing if anyone has accomplished this.

The only thing that I have done is to...

Sorry - I don't know that this is possible as well & I'd be interested in knowing if anyone has accomplished this.

The only thing that I have done is to...

Hi,

I'm not quite sure I understand what it is that you're trying to do but if you want to update a table in your database by using a stored procedure...

Unfortunately, a lot of the bugs that are reported are the "lipstick on chicken" variety or complaints about shades of the lipstick used...

One of the main reasons why those d%$#...