Post reply

MS SQL VIEW Problem

  • April 11, 2009 at 2:12 pm

    #130010

    I have a view where i need to combine 2 feilds, my code is as follows:

    CREATE VIEW dbo.view1 (

    [test_combo]

    )

    AS

    SELECT

    dbo.listing.link+dbo.listing.ID

    FROM

    dbo.listing

    The problem I am having is that since one feild is text and the other is numeric the join doesnt work. I have made this work with two text fields.

    Basically what I am trying to do is combine fields to make make a link like this: http://www.1.com/1.asp?ID=%5BID%5D

    How do I convert this to all text?

  • April 11, 2009 at 4:09 pm

    #976213

    Look up CAST and COVERT functions in books online :).

    Mohit.

    [font="Arial"]---

    Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
    Microsoft FTE - SQL Server PFE

    * Some time its the search that counts, not the finding...
    * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

    How to ask for help .. Read Best Practices here[/url].

  • April 11, 2009 at 5:06 pm

    #976224

    Thanks,

    Seached, found, working perfectly!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply