I want a default value of space

I'm using MSDE and I'd like to set a default value of a space (or spaces), and in design-view, it lets me enter a space. But it is interpreted as an empty-string "" which gets converted to Nulls when it is moved to another string field? I'm not sure why. Is there any way around this?
Are wrapping it in quotes?|||In testing, no matter what I do I cannot make SQL Server assign thedefault value of a single space or multiple spaces to a column. It always assigns an empty string. For reference, this is what Iam indicating for the default value:
(' ')
I thought it might have had to do with the varchar data type, so Ichanged it to char and had the same result. I am also stumped.
|||

It's nice to know I'm not alone. I'm doing the same - wrapping it in quotes. The problem is - it is interpreted as hex '00' when I move it to another string (which is part of a record I'm transmitting to a remote server) and this server can not handle NULL values. So unless I find a solution, I have to convert all with "empty-string" to " " before I send them. ouch.

If you find a solution, please let me know and I'll do the same.

Thanks,

John Pavelka

I need to put my main page on IE when some one request for it.

Hi

Can anybody tell me that how can i configure the things that will show my main report page when i enter Url like http://localhost/ReportServer. It gives directory struction first & then we have to select particular report

Rajnish

Hi Rajnish,

You can provide the entire URL, not just the directory name. Something like this: http://Servername/ReportServer/Pages/ReportViewer.aspx?%2fReportName&rs:Command=Render

i need to ask a question.

how do i enter a new question?
i click new and nothing happens
--
thank you
ms. soto
"SouRa" wrote:

> Hi all,
> By default all the values in the result set are left aligned. But
> I want to align a column in a result set of a query to right side...
> Is it possible in SQL?
> Example:
> Charges
> 11145.00
> 171.00
> 26.00
> 6.00
> Result should be
> Charges
> 11145.00
> 171.00
> 26.00
> 6.00
> Please advise
> Thanks,
> SouraHi
That will depend on how you are using the newsgroup, for instance if you are
using the technet communities
http://www.microsoft.com/technet/co...server/sql.mspx you
will need to create a profile and use a passport to sign in before adding ne
w
messages or replying to existing messages. As you can reply then it looks
like you have this, in which case you would need to select the new button
which is just beneath the "search for:" area. If you are using Outlook
Express choose the New Post button or File/New/News Message from the menu.
HTH
John
"ms. soto" wrote:
[vbcol=seagreen]
> how do i enter a new question?
> i click new and nothing happens
> --
> thank you
> ms. soto
>
> "SouRa" wrote:
>

I need help with date parameter issue

I have a report which I can search by a startdate and enddate. I want to have the parameter fields automatically enter the / / for the date example 01/01/2007 I just want to type 01012007 and have it enter 01/01/2007. How can this be accomplished. can some on show me a piece of code that can do this. I have heard of mask but do not now how to apply this to a parameter.

This should help:http://blogs.msdn.com/bradsy/archive/2006/04/04/568295.aspx

-Damien

|||

Thanks, I already now how to get the date format nte way I want it . I am just stuggling with how to have the parameter box have the // in it for the date I have to typr the // in with the date and I am trying to figure out how to have it fill this in when I type 01012007 and further help would be great