Professional Web Applications Themes

concatenate text fields - Microsoft SQL / MS SQL Server

Does anyone know of a workaround to concatenate text fields???? thanks, jr...

Sponsored Links
  1. #1

    Default concatenate text fields

    Does anyone know of a workaround to concatenate text fields????

    thanks,
    jr


    Sponsored Links
    jr Guest

  2. #2

    Default Re: concatenate text fields

    Thanks Aaron ,
    I am having trouble getting the length of the text field...can you point me
    in the right direction. LEN doesnt seem to work for text.....

    Thanks,
    jr
    "Aaron Bertrand - MVP" <aaronTRASHaspfaq.com> wrote in message
    news:Ougw6kVRDHA.2144TK2MSFTNGP11.phx.gbl...
    > Yes, do it at the client application.
    >
    > Or, if the text fields contain < 8000 characters of data, then convert
    them
    > to VARCHAR.
    >
    > Or, find out the datalength, /8000, add 1... you need that many variables,
    > and you can use SUBSTRING to populate them.
    >
    >
    >
    > "jr" <jrjr.com> wrote in message
    > news:ey9l6hVRDHA.2020TK2MSFTNGP11.phx.gbl...
    > > Does anyone know of a workaround to concatenate text fields????
    > >
    > > thanks,
    > > jr
    > >
    > >
    >
    >

    jr Guest

Similar Threads

  1. Text edit functions not working for text entry fields onMAC
    By Brij_Mohan in forum Macromedia Flex General Discussion
    Replies: 0
    Last Post: May 13th, 02:19 PM
  2. Flowing text in separate, adjacent text fields.
    By dave_thayer@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 0
    Last Post: February 4th, 05:37 PM
  3. Concatenate fields with no values
    By Pubcit in forum Coldfusion Database Access
    Replies: 1
    Last Post: July 15th, 03:41 PM
  4. Concatenate Fields to >255 chars
    By Simon Dallmair in forum Coldfusion Database Access
    Replies: 0
    Last Post: March 18th, 10:47 AM
  5. Dynamic text fields. Continuing text over columns
    By gaz f webforumsuser@macromedia.com in forum Macromedia Flash Actionscript
    Replies: 0
    Last Post: January 15th, 10:32 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139