Introduction
Write a SQL query to get firstname from tblstudent with Hello prefix. I have used Microsoft SQL server 2008 R2 for the following demo.
SELECT 'Hello ' + firstname FROM tblStudent
Result
![Write a SQL query to get firstname from tblstudent with Hello prefix](https://techstudys.com/wp-content/uploads/2021/08/19.png)
Write a SQL query to get firstname from tblstudent with Hello prefix. I have used Microsoft SQL server 2008 R2 for the following demo.
SELECT 'Hello ' + firstname FROM tblStudent