RE: CONVERT TO SQL SERVER

From: Borislav Borissov


	Sofia Bulgaria
	Borislav Borissov

To: DEREK DODOO


	READING, UK United Kingdom
	DEREK DODOO

Subject:	RE: convert to sql server
Thread ID:	469483	Message ID:	469484	# Views:	54	# Ratings:	0
Version:	Not Applicable		Category:	Databases, Tables and SQL Server
Date:	Wednesday, October 23, 2019 4:58:01 PM

> SELECT VPAYCURRT.IDNO ,
> (PADR(VPAYCURRT.FNAME,30)+' '+PADR(VPAYCURRT.LNAME,30)) AS DESCPTN,
> PADR(VPAYCURRT.LEVEL1,40) AS LEVEL1 ,
>
>
> Convert the undernoted to sql server
>
>
>

(PADR(VPAYCURRT.FNAME,30)+' '+PADR(VPAYCURRT.LNAME,30)) AS DESCPTN,

Why padding?

-----------------
Borislav Borissov

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.

ENTIRE THREAD

convert to sql server Posted by DEREK DODOO @ 10/23/2019 4:22:27 PM

RE: convert to sql server Posted by Borislav Borissov @ 10/23/2019 4:58:01 PM

RE: convert to sql server Posted by Cetin Basoz @ 10/23/2019 5:14:41 PM

RE: convert to sql server Posted by Tore Bleken @ 10/23/2019 5:22:50 PM

RE: convert to sql server Posted by Cetin Basoz @ 10/23/2019 6:08:15 PM

RE: convert to sql server Posted by Noker Lodia @ 10/23/2019 8:47:33 PM

RE: convert to sql server Posted by Cetin Basoz @ 10/23/2019 11:07:30 PM