>>
>>Sergey,
>>
>>PMFJI. How is the text-merge different from using a variable? For example,
>>
>>
>>cSqlCommand = "select myPrimaryId, mySecondayId,cDtTitle, " + ;
>>"cEnTitle, cDtMaterial, cEgMaterial,ceDtFormat, ceEgFormat, " + ;
>>"coalesce(DtPrtcopy,'') as DtPrtcopy, " + ;
>>"coalesce(EgPrtcopy,'') as EgPrtcopy, " + ;
>>"coalesce(DtSPrice,'') as DtSPrice " + ;
>>" from HORSART_WORKS "
>>
>>
>>It seem like eithre method is limited 255 characters. Correct?
>
>The textmerge method makes code easier to read, maintain and troubleshhot. For example, you can copy a query between TEXT...ENDTEXT into QA or SSMS and run with litle modifications.
>
>I'm not sure what 255 charaters limit for the textmerge you cite.
I meant the 255 character limit of a string. That is, whether you create the variable using TEXT .. ENDTEXT or otherwise, the resulting variable cannot be greater than 255.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham