Recent content by RobNotKnowing

Hi,,,, I am trying to replace the Nulls with blanks in my query output. Does any1 know how?

Hi,,,, I am trying to replace the Nulls with blanks in my query output. Does any1 know how?

sql server table sorry for the misunderstanding.

Server: Msg 1038, Level 15, State 3, Line 3 Cannot use empty object or column names. Use a single space if necessary. Server: Msg 195, Level 15, State 1, Line 3 'Nz' is not a recognized function name. Server: Msg 1038, Level 15, State 1, Line 4 Cannot use empty object or column names. Use a...

select loan_no_i,loan#,prevloan#,invloan#,fname,lname, add1,add2,city,state,zip,upb,daysdelq,gracedays,nextdue,totaldelq, intrate,propadd1,propadd2,propcity,propstate,propzip,cg.homephone,cg.workphone, [b2 homephone],[b2 workphone],perdiem,lastrecd,loandate,loanamt,investor, pool,ssn,[b2...

due I put that after the word select or after my inner join?

Hi,,,, I am trying to replace the Nulls with blanks in my query output. Does any1 know how?

Thanks...I will try that.

Maybe it is port forwarding. I need to have the internal server (10.11.20.10) to be able to be accessed by an outside vendor 100.101.102.x

It is a pix 515e version 6.3(3) sorry

I have to point one of our vendors (100.101.102.x) to our server on our local network 10.11.20.10 through port ssh 22 tcp. does anyone know how to do this? Thanks

Thanks

Sorry. I meant I want to show the whole # but sort it my the customer #. ex. if customer number is 123456789 and 1234567890 I want the one first customer # 123456789 to be on the page that shows the last digit ending between 5-9 and customer id 1234567890 on another page since it is between...

Hi All, I am new to Crystal and I need to take a report that we have and sort it by ending cutomer #. Example. We want to have the report where the Customer # will have everything ending in 0-4 on one page and 5-9 on the next page. Any ideas on how to set this up? Thank you!!

Hi All, I am new to SQL and I am trying to export from a dts to a .csv file. Is there anything special that I need to do? Thanks in Advance!