CHAR(13)+CHAR(10)

select 'one' union select 'two' union select 'three'




but what are you trying to do exactly?

If you are working with MS Access, change the CHARs to Chr.  Ie:

select 'one' + CHR(13) + CHR(10) + 'two' + CHR(13) + CHR(10) + 'three'

CHR(13) + CHR(10) is carriage return/Linefeed and will give you the vertical breaks shown.

deighton, that was a simple example that i gave.. yes, union is a good idea.. but actually the code will inserting one line at a time in a varchar(max) field.. so union won't work there.. we want the result to be listed as separate lines not all together.

mbizup, CHR is not in sql. so you get the
1
2
3
output in access with the same logic?

Yes.  Using an Access UI, your query would be using the VBA Chr() function, and 'stacks' the numbers as displayed.  You would have to change the +'s to &'s, though:


select 'one' & CHR(13) & CHR(10) & 'two' & CHR(13) & CHR(10) & 'three'