I have two fields that I would like to combine into 1 field is this possible.
Example: Document # 555, Doc Description ABCD in the 3 field I would like 555-ABCD.
Is that possible in SQL Server thankscould you provide us some info as outlined in the hint sticky that's on top of the board?|||Select DocNoc, DocDesc from DocTable (take these to fields and insert it into one field in the same table.
Insert into DocNumDesc
How would I go about creating this syntax. Thanks|||SELECT DocNoc+DocDesc
??|||Okay is the correct syntax:
INSERT INTO DocNumDesc
SELECT DocNoc +DocDesc
FROM DocTable
Thanks
Showing posts with label abcd. Show all posts
Showing posts with label abcd. Show all posts
Subscribe to:
Posts (Atom)