Interview Questions - Find the maximum Alphanumeric value

Getting Started with Adobe After Effects - Part 6: Motion Blur

This module helps you to share, discuss and learn interview questions and answers of different technologies

Home · Most Liked · Most Asked · Most Discussed · Sections

Find the maximum Alphanumeric value

Jan 28 2012 11:32PM by Ravi Tuvar

How can we find the maximum Alphanumeric value in the primary key?

Select 'prefix' + convert(varchar(20), max(convert(int, substring(AlphNumField, 4, 100))) + 0) from TableName

Read More.. [55 clicks]

Ravi Tuvar

605 · 0% · 58

Liked

Asked


Post this to my facebook wall
Tweet this
Like this
I have asked or faced this question during an interview

Your Comment

Sign Up or Login to post a comment.

"Find the maximum Alphanumeric value" rated 5 out of 5 by 2 readers