First Initial (1 Viewer)

[New2SQL]

How do i trim a name in a string.

I have 2 rows with firstname in one and the second has surname. if i wanted to view the results to have A Einstein rather than Albert Einstein, how would this be done?

thanks.

 

[MartijnR]

You can use a query with an expression that combines the 2 colums. If you rightclick in a field, when designing a query, you can use the build option. In the build option, find the function you need, use & (to combine fields or expressions) and the other field

At least, if you are using 2 colums in stead of 2 rows like you describe. (colums are vertical, fields in 1 record, rows are horizontal, the records in a table)