Buy Questpond's video subscriptions on
huge discount
.
Online: 2318
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Interviews
>
Sql Server
>
Loading ...
You've created a simple select statement that returns the customers first name and last name. This statement needs changing so that it only includes the customers first initial and their last name in the result set. There is no column for initial. Which function could you use to get the initial?
Posted by
Bandi
on 7/30/2014 | Category:
Sql Server Interview questions
| Views: 1549 |
Points: 40
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
Select from following answers:
SUBSTRING
STUFF
REPLACE
RTRIM
All Above
SUBSTRING is more suitable to get the initial data from first name
Show Correct Answer
Asked In:
Many Interviews |
Alert Moderator
Bookmark It
< Previous :
Which of the following generates control-breaks an ...
Next > :
Your manager has asked you to design a new table a ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
Your manager has asked you to design a new table and enforce rules for ...
which of the following SP will be useful to show the active user conne ...
One of the developers at your company has written a CLT stored procedu ...
Side by side upgrades are a common choice when installing SQL 2008 alo ...
Your manager has asked you to create a new user on SQL Server 2008 tha ...
What is the name given to the column or combination of columns whose v ...
A developer in your organization has added a new table to the company ...
Your company has just launched a new in-house application for call mon ...
Latest Interview Questions
By default,Asp.Net stores SessionIDs in which mechanism?
In order to prevent a browser from caching a page which of the stateme ...
We have defined one page_load event in aspx page and the same is defin ...
How to display a computer code in html
What is the FEATURES or PURPOSE of Raise Error?
Can a Clustered Index ALSO be a Unique Index?
Which statement is used for defining a Cursor?
Which Process is used for Maintaining State Server Session in Asp.Net ...
More ...