sql syntax

[kongyu]

Hi,
i need your help in SQL syntax.
Let say i had a field name Book_No and data such as AH38JKJ98J.
Meaning Book_No = AH38JKJ98J.
What are the SQL syntax to just retrive "H38JK" from the Book_No??
VB syntax is Mid(Book_No, 2,5), how about SQL?? TQ.

 

[tlbroadbent]

Use the substring function in T-SQL.

substring(Book_No, 2, 5) Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[kongyu]

Hi Terry
Thank you for your help. Finally i get the answer. TQ.

Regards,
Tan