Click here to Skip to main content
12,632,326 members (29,936 online)
Rate this:
 
Please Sign up or sign in to vote.
Hi,
I am using this line of code show error to my clients...

SET @ErrorMessage = ''  ~ Customer Personal Primary ID is expiring in '' + LTRIM(STR(@DATEDifferenceID1)) + '' Days.Would you like to proceed and save the remittance?''


the result of this code is
Customer Personal Primary ID is expiring in X Days.Would you like to proceed and save the remittance?



My main problem is this,
i want to show this message to my client in two lines,such like this one

Customer Personal Primary ID is expiring in X Days.
Would you like to proceed and save the remittance?


how can i do this in sql...?
Posted 16-Sep-12 22:39pm

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Hi,


Use like,

Char(13) or Char(10) may work for you.

SET @ErrorMessage = ''  ~ Customer Personal Primary ID is expiring in '' + LTRIM(STR(@DATEDifferenceID1)) + '' Days. '' + Char(13) + '' Would you like to proceed and save the remittance?''


This may work for you.
  Permalink  
Comments
prince_rumeel 17-Sep-12 4:09am
   
<pre lang="SQL">SET @ErrorMessage = '' ~ Customer Personal Primary ID is expiring in '' + LTRIM(STR(@DATEDifferenceID1)) + '' Days. '' + Char(13) + '' Would you like to proceed and save the remittance?''</pre>

This Work For Me Too Nice.My Problem Has Been Solve Out.
Thanks Alot @amitgajjar
@amitgajjar 17-Sep-12 4:10am
   
Your welcome.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.161208.2 | Last Updated 17 Sep 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100